| | How to enable auditing in Oracle database
For Oracle versions prior to 9 set audit_trail parameter in ini file i.e.:
audit_trail = DB
For Oracle 9 and later:
alter system set audit_trail = DB;
If you want to audit a specific user run the following:
audit alter table, select table, insert table, update table, delete table, grant table, grant procedure by USERNAME;
To ... | | More...
11/08/07 | | | | |
|
|
|
| | How to switch to another user
Need to become a different Oracle database user? There is a way to login into a another user's account without knowing their password:
1. Find out the encrypted password for the user
SQL> select username, password from dba_users where username = 'USERNAME';
USERNAME PASSWORD
------------ ------------------------------
USERNAME ... | | 
More...
02/07/06 | | | | |
|
| | How to create externally identified user
This is an example how to create externally identified user in Oracle; i.e. if you want the os oracle user to connect to database without supplying password run the following statement from sqlplus:
SQL> create user OPS$ORACLE identified externally
default tablespace users
temporary ... | | More...
02/07/06 | | | | |
|
|
|
