Showing posts with label user management. Show all posts
Showing posts with label user management. Show all posts
Saturday, July 27, 2013

Grant role access to all objects in a schema to another user

›
BEGIN FOR i IN (SELECT object_name FROM user_objects WHERE object_type in ('PROCEDURE','PACKAGE','FUNCTION') ) LOO...
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 ...
Friday, May 4, 2012

Track User password change Audit Activity

›
if you want to track password change or other activity with sql then ALTER SYSTEM SET AUDIT_TRAIL=DB_EXTENDED SCOPE=SPFILE; THERE IS SQ...
Monday, April 23, 2012

Connect as an Oracle User Without Knowing the Password

›
SQL> alter user ldbo grant connect through ksh; User altered. SQL> connect n/ksh$1#@apx1112srv; Connected. SQL> show user US...
Wednesday, March 28, 2012

Role Creation Using Network Link

›
BEGIN FOR cur_rec IN (SELECT role FROM dba_roles@lnk_previousyearbalance) LOOP BEGIN EXECUTE IMMEDIATE 'C...

User Creation using Network Link

›
------------Create profile BEGIN FOR cur_rec IN (SELECT distinct profile,Resource_name,limit FROM dba_profiles@lnk_prev...
Thursday, March 15, 2012

Role Recreation

›
set heading off verify off feedback off echo off term off linesize 200 wrap on spool c:\temp\roles_creation.sql SELECT 'Create Role ...
Wednesday, August 11, 2010

User Creation Script for prev YR

›
set heading off verify off feedback off echo off term off linesize 200 wrap on spool c:\temp\Recreate_Users.sql SELECT distinct 'create ...

Create Like User Script

›
spool c:\usercreation.sql set pages 0 feed off veri off lines 500 accept oldname prompt "Enter user to model new user to: " accept...

Password reset same as before fro all users

›
set heading off verify off feedback off echo off term off linesize 200 wrap on spool c:\password_users.sql SELECT 'alter user ' || u...