This preview shows pages 1–2. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: Create password file if it does not already exit Verify that REMOTE_LOGIN_PASSWORD_FILE is set to EXCLUSIVE Grant SYSOPER or SYSDBA privilege to users Query V$PWFILE_USERS to verify the password file members 07_DICTIONARY_ACCESSIBILITY = TRUE REVOKE ALTER ANY TABLE FROM BOB; Object Privileges To grant an object privilege, the object must be in your schema, or you must have been granted the privilege with the WITH GRANT OPTION. If you own an object, all privileges on that object are automatically acquired with the WITH GRANT OPTION. For security reasons, use creation while granting privileges on your objects. The WITH GRANT OPTION cannot be used to grant privileges to roles. SELECT * FROM dba_sys_privs; - info. About system privileges from data dictionary SELECT * FROM dba_col_privs;- info. About object privileges...
View Full Document
This note was uploaded on 02/25/2010 for the course MAT 443 taught by Professor Roberts during the Winter '10 term at University of Arizona- Tucson.
- Winter '10