Chapter 13 Managing Database Access


Analyzing system privileges

System privileges vary according to the DBMS you are using. The list of privileges also includes predefined roles (like connect, or resource) for an easier use.

System privileges are granted to a user, which means the user is authorized to use a certain privilege. A user with administrative profile is also allowed to revoke a privilege in order to prevent a user from performing certain actions over the database content.

The list of predefined system privileges allowed in the current DBMS is available in the System entry under Script\Object\Privileges in the DBMS resource file. The Privileges category also contains entries used to provide the syntax for the different order corresponding to the DBMS privileges.

 


Copyright (C) 2005. Sybase Inc. All rights reserved.