Search
Tag Cloud
10.2.0.5 10g 11.1 11.2 ADR agent alertlog ASM base64 bug bundle patch codetable constraint database database appliance digest diskgroup encryption enterprise manager gi grid control grid infrastructure hashes LinkedIn listener monitoring oak oakcli ODA OEM ORA oracle oracle database appliance password patch bundle PLSQL privileges RAC sha1 solaris timestamp troubleshooting unwrap wrap zipCategories
-
Recent Posts
Blogroll
Tag Archives: privileges
Oracle RAC – granting SYSDBA or SYSOPER is instance specific
The default location for the password file is $ORACLE_HOME/dbs which in most cases (if you don’t have your ORACLE_HOME on a shared disk) is on a non-shared filesystem. Whenever you grant SYSDBA or SYSOPER to a database user Oracle will … Continue reading
Posted in RAC
Tagged 11.2, database, database appliance, LinkedIn, ODA, oracle, oracle database appliance, password, password file, privileges, RAC, SYSDBA, SYSOPER
Leave a comment
Creating database links for another schema
There are situations (like after cloning databases) where you, as a DBA, want to create database links in other schema’s, for which you don’t have the password. Unfortunately the security of Oracle doesn’t allow (even SYS) you to drop/create database … Continue reading
Posted in Database
Tagged database, DBMS_IJOB, DBMS_SYS_SQL, LinkedIn, ORA-01031, oracle, PLSQL, privileges, run_sql_as
4 Comments
Privileges for AWR reporting
Sometimes during a project there are people that would like to generate AWR reports. Here are the privilges on certain database objecs that a user needs to be able to generate such reports using SQL*Plus (in this case granted to … Continue reading
Posted in Database
Tagged AWR, database, DBMS_WORKLOAD_REPOSITORY, LinkedIn, oracle, privileges
Leave a comment