DBA FUS‎ > ‎

Access Control Queries

posted Sep 13, 2010, 5:54 AM by Sachchida Ojha
Select value from v$parameter where name= 'instance_name';
select 'Audit data is stored to: '||value from v$parameter where name='audit_trail';
select 'The AUDIT_FILE_DEST is set to: '||value from v$parameter where name='audit_file_dest';
Select value from v$parameter where name='user_dump_dest';
Select value from v$parameter where name='background_dump_dest';
Select value from v$parameter where name='core_dump_dest';
Select log_mode from v$database;
Select value from v$parameter where name='os_roles';
Select value from v$parameter where name= 'audit_sys_operations';
Select value from v$parameter where name= 'global_names';
Select value from v$parameter where name= '_trace_files_public';
Select value from v$parameter where name='audit_trail';
Select value from v$parameter where name= 'os_authent_prefix';
Select value from v$parameter where name='remote_os_authent';
Select value from v$parameter where name='remote_os_roles';
Select value from v$parameter where name='sql92_security';
Select value from v$parameter where name='utl_file_dir';
Select value from v$parameter where name='O7_DICTIONARY_ACCESSIBILITY';

Show parameter log_archive_dest;
Show parameter log_archive_duplex_dest;
show parameter os_roles;
show parameter audit_trail;


Comments