Showing posts with label security. Show all posts
Showing posts with label security. Show all posts
Thursday, February 14, 2013

synonym - after dba privileges user is not able to access the option. only schema owner can access

›
create or replace trigger logon_trg    after logon on database  begin     if user in ('A','B') then         execute imm...
Friday, August 24, 2012

RESTRICT NON DBA USER TO ACCESS DEVELOPMENT TOOLS LIKE SQLPLUS , TOAD,...

›
Create or Replace TRIGGER TG_OTHER_TOOL   v_prog sys.v_$session.program%TYPE;   v_module sys.v_$session.program%TYPE ; lnUsercode number...
Thursday, August 23, 2012

Restrict Users to access other application exe

›
create or replace procedure sp_ltmlogin AS   MODULE SYS.V_$SESSION.MODULE%TYPE ; L_USER NUMBER ; BEGIN  SELECT MODULE INTO MODULE FROM ...
Wednesday, August 8, 2012

Two User Logon Not Allowed on same Machine

›
create or replace trigger TG_SINGLELOGIN after logon on database declare cnt pls_integer; begin select count(*) into cnt from v$sessio...

Concurrent User Login Denied from Different Machine

›
create or replace trigger TG_MULTILOGIN after logon on database declare cnt pls_integer; begin select count(*) into cnt from v$session...

User Machine Specific Access

›
suppose you have five machines and five users (   one user per machine ) Note: these users are database users... e.g User name ...
Thursday, December 29, 2011

Database Hardening

›
Following are the general guidelines used for DB hardening: Complete server hardening checklist. Ideally, run on latest supported version (...