CODEWITHSUNDEEP
sql-serversql-server-2008
David Rodecker
David Rodecker

Reputation: 127

"public" SQL user always given EXECUTE & SELECT permissions

Whenever I add a basic SQL 2008 user to the server and map it to a particular database with Public access, the user has the effective permission as EXEC and SELECT.

This is only happening in one database. I have checked the SQL Management interfaces and affirmed that that there is no explicit granting at the DB or Server level for this newly created user. The default schema for the user is dbo.

I have read the settings as described in: "public" role access in SQL Server, to no avail.

Upvotes: 0

Views: 1589

Answers (1)

AnthonyJ
AnthonyJ

Reputation: 435

My suggestion would be to create your own database role and assign permissions accordingly, that way you control the access on the database explicitly.

In regards to the Public role, the server administrator can set the permissions for the Public role and these inherit to all the databases so you are best to only use it if you control the server in my opinion.

Hope this helps

AJ

Upvotes: 1

Related Questions