Solution : https://service.sap.com/sap/support/notes/700548 (SAP Service marketplace login required)
Summary :
This SAP Note addresses frequently asked questions related to database authorizations, detailing what they are, their different types, and methods for management within the SAP environment. It clarifies authorization types like privileges (system and object) and roles (including predefined ones like CONNECT, DBA, and SAP-defined roles like SAPDBA). It guides on assigning and deleting these authorizations using commands like GRANT and REVOKE to control users' access to database resources. Also, it discusses handling errors like ORA-00942 or ORA-01031 due to missing authorizations and offers best practices, citing specific SAP Notes for in-depth guidance on ensuring database security.
Key words :
database tablesalter user -> execute alter user commandsdrop tablespace -> delete tablespaces, sapr3 / sap<sid> / sap<xyz> / sap<sid>db, alter user <user> default role <role1>, terms frequently asked questions solution 1, execute oracle ddic packages select_catalog_role, delete oracle ddic objects execute_catalog_role, oracle automatically encrypts passwords, execute operating system commands, create table -> create tables, object privilege refers table_name
Related Notes :
| 1623922 | |
| 1622837 | Secure connection of AS ABAP to Oracle via SSFS |
| 1551504 | Cleaning up Oracle audit files |
| 1431798 | Oracle 11.2.0: Database Parameter Settings |
| 1028220 | ORA-01031: Insufficient privileges despite SAPCONN role |
| 951167 | ORA-28000: the account is locked |
| 926023 | Oracle database security |
| 834917 | Oracle Database 10g: New database role SAPCONN |
| 832662 | Audit-friendly configuration of BR*Tools on Unix |
| 736313 | ORA-00942 when accessing Oracle dictionary tables |
| 662644 | Composite SAP Note: ORA-00942 |
| 652781 | Error due to product user profile |
| 644104 | ORA-01536/ORA-01950 |
| 640553 | Database error during explain: ora-1039 ora-905 ora-942 |
| 608510 | DBIF_DSQL2_OBJ_UNKNOWN in db02 or st04 |
| 582427 | Error due to inconsistent Oracle DDIC |
| 562863 | FAQ: Logon mechanisms |
| 400241 | Problems with ops$ or sapr3 connect to Oracle |
| 313412 | Syslog message: "Database error ... for XPL" |
| 134592 | Importing the SAPDBA role (sapdba_role.sql) |