sa_serverprivs_role

The sa_serverprivs_role is a user-defined role granted to the sa by default, and ensures the system administrator possesses all privileges necessary to run Adaptive Server when enable granular permissions is enabled. As a user- defined role, when granted to a login, sa_serverprivs_role is not activated automatically for the login during login by default.

You can use alter login to enable automatic activation of this role during login.

Sybase recommends that you do not use sa_serverprivs_role as a regular user-defined role.

When you enable enable granular permissions, the sa login has the same privileges in a database as the database owner. The sa login can obtain other database-wide privileges by adding himself as a user of the database, and granting himself those privileges.

Default privileges granted to sa_serverprivs_role are listed in Table 8-13.

**Table 8-12: Privileges granted to sa_serverprivs_role by default**
allow exceptional login
change password
checkpoint any database
connect
create database
dbcc checkalloc any database
dbcc checkcatalog any database
dbcc checkdb any database
dbcc checkindex any database
dbcc checkstorage any database
dbcc checktable any database
dbcc checkverify any database
dbcc fix_text any database
dbcc indexalloc any database
dbcc reindex any database
dbcc tablealloc any database
dbcc textalloc any database
dbcc tune
dump any database
kill any process
load any database
manage any database
manage any ESP
manage any execution class
manage any login
manage any login profile
manage any remote login
manage auditing
manage cluster
manage data cache
manage disk
manage dump configuration
manage lock promotion threshold
manage resource limit
manage roles
manage security configuration
manage security permissions
manage server
manage server configuration
manage server permissions
map external file
mount any database
online any database
own any database
quiesce any database
select on authmech
select on get_appcontext
select on list_appcontext
select on rm_appcontext
select on set_appcontext
set switch
set tracing any process
show switch
shutdown
unmount any database