Showing posts with label granted. Show all posts
Showing posts with label granted. Show all posts

Friday, March 9, 2012

Definition of specific "Security Roles"

Under SSMS I see the "securityadmin" Server role. Where in SSMS can I find the actual list of permsisions granted to this role? (not just a generic description of what this role can do.)

TIA,

Barkingdog

In summary they can add members to the securityadmin role, Grant or deny CREATE DATABASE and read the error logs. Additionally they are allowed to use the tasks:

sp_addlinkedsrvlogin,sp_addlogin,sp_defaultdb,sp_defaultlanguage,sp_denylogin,sp_droplinkedsrvlogin,sp_droplogin,sp_grantlogin,sp_helplogins,sp_remoteoption and sp_revokelogin.

The above mentioned list is from an old SQL 2000 scripts of mine. Additionally the description of the BOL and the appropiate command which are new for the above mentioned procedures apply.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

Tuesday, February 14, 2012

default public permissions

Can anyone tell me what are (or where to find) the default permissions
granted to the public role? I think that permissions are granted not only in
the user database in question, but also in the system databases? Please let
me know. Thanks.
Yes, the public role is granted specific permissions in every db by default.
You can change these by expanding the DB in Enterprise Manager, Databases,
Expand the database in question, expand Roles. Double click Public. Click
the Permissions button.
You should see exec perms on a bunch of system stored procs, system tables
in the user db, etc.
Notice that by default the public role doesn't get permissions on every
object in the db.
You can change the public role's permissions here, but be sure to compensate
by giving those permissions to the users that will need it through another
role.
Every user in the db is in the public role, so the changes you make will
affect everyone. So, don't deny permissions, just remove them.
Donna Lambert
"J Jetson" wrote:

> Can anyone tell me what are (or where to find) the default permissions
> granted to the public role? I think that permissions are granted not only in
> the user database in question, but also in the system databases? Please let
> me know. Thanks.
|||Hi,
See this article:-
http://www.databasejournal.com/featu...le.php/1478701
Thanks
Hari
SQL Server MVP
"J Jetson" <JJetson@.discussions.microsoft.com> wrote in message
news:333F33A8-C4AA-4CFC-B0F3-DAE1BDD6F128@.microsoft.com...
> Can anyone tell me what are (or where to find) the default permissions
> granted to the public role? I think that permissions are granted not only
> in
> the user database in question, but also in the system databases? Please
> let
> me know. Thanks.

default public permissions

Can anyone tell me what are (or where to find) the default permissions
granted to the public role? I think that permissions are granted not only in
the user database in question, but also in the system databases? Please let
me know. Thanks.Yes, the public role is granted specific permissions in every db by default.
You can change these by expanding the DB in Enterprise Manager, Databases,
Expand the database in question, expand Roles. Double click Public. Click
the Permissions button.
You should see exec perms on a bunch of system stored procs, system tables
in the user db, etc.
Notice that by default the public role doesn't get permissions on every
object in the db.
You can change the public role's permissions here, but be sure to compensate
by giving those permissions to the users that will need it through another
role.
Every user in the db is in the public role, so the changes you make will
affect everyone. So, don't deny permissions, just remove them.
Donna Lambert
"J Jetson" wrote:
> Can anyone tell me what are (or where to find) the default permissions
> granted to the public role? I think that permissions are granted not only in
> the user database in question, but also in the system databases? Please let
> me know. Thanks.|||Hi,
See this article:-
http://www.databasejournal.com/features/mssql/article.php/1478701
Thanks
Hari
SQL Server MVP
"J Jetson" <JJetson@.discussions.microsoft.com> wrote in message
news:333F33A8-C4AA-4CFC-B0F3-DAE1BDD6F128@.microsoft.com...
> Can anyone tell me what are (or where to find) the default permissions
> granted to the public role? I think that permissions are granted not only
> in
> the user database in question, but also in the system databases? Please
> let
> me know. Thanks.

default public permissions

Can anyone tell me what are (or where to find) the default permissions
granted to the public role? I think that permissions are granted not only in
the user database in question, but also in the system databases? Please let
me know. Thanks.Yes, the public role is granted specific permissions in every db by default.
You can change these by expanding the DB in Enterprise Manager, Databases,
Expand the database in question, expand Roles. Double click Public. Click
the Permissions button.
You should see exec perms on a bunch of system stored procs, system tables
in the user db, etc.
Notice that by default the public role doesn't get permissions on every
object in the db.
You can change the public role's permissions here, but be sure to compensate
by giving those permissions to the users that will need it through another
role.
Every user in the db is in the public role, so the changes you make will
affect everyone. So, don't deny permissions, just remove them.
Donna Lambert
"J Jetson" wrote:

> Can anyone tell me what are (or where to find) the default permissions
> granted to the public role? I think that permissions are granted not only
in
> the user database in question, but also in the system databases? Please le
t
> me know. Thanks.|||Hi,
See this article:-
http://www.databasejournal.com/feat...cle.php/1478701
Thanks
Hari
SQL Server MVP
"J Jetson" <JJetson@.discussions.microsoft.com> wrote in message
news:333F33A8-C4AA-4CFC-B0F3-DAE1BDD6F128@.microsoft.com...
> Can anyone tell me what are (or where to find) the default permissions
> granted to the public role? I think that permissions are granted not only
> in
> the user database in question, but also in the system databases? Please
> let
> me know. Thanks.