System and Object privileges can be combined and formed as different roles in the database system. If we assign a database role to a particular user of a database, that user will be granted all the privileges included in the role assigned.

The most important role in the database is DBA. The DBA role contains all the  privileges necessary for database administration. However, we can not fully administer the Oracle instance with this role because this role does not contain the privileges SYSDBA or SYSOPER. These privileges are necessary for starting  and shutting down the oracle instance.

Generally, We can create any number of database roles in an Oracle database. The SAP installation creates just one additional database role called SAPDBA. Based on object privileges, this role gives a user the ability to access certain tables used by SAP tools for database administration. Examples of such tables are DBSTATC, SDBAD, DBSTATHORA…

This entry was posted on February 11, 2012 at 9:33 AM. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Posted in SAP Basis Notes by Raj No Comments Yet