Search
Tag Cloud
10.2 10.2.0.5 11.1 11.2 ADR alertlog ASM bug bundle patch cleanupDeploy database database appliance digest diskgroup enterprise manager gi grid control grid infrastructure GrindInst hashes LinkedIn listener localhost monitoring oak oakcli ODA odachk OEM one-off ORA oracle oracle database appliance password patch bundle PLSQL privileges RAC REDO sha1 solaris troubleshooting usable_file_mb x-windws xtermCategories
-
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