meta données pour cette page
  •  

Ceci est une ancienne révision du document !

USERS

  • Liste des users non système
SET lines 600
col USERNAME format a30
col ACCOUNT_STATUS format a20
col DEFAULT_TABLESPACE format a20
col PROFILE format a20
col LAST_LOGIN format a20
SELECT USERNAME,CREATED,ACCOUNT_STATUS,DEFAULT_TABLESPACE,PROFILE,LAST_LOGIN 
FROM dba_users
WHERE default_tablespace NOT IN('SYSTEM','SYSAUX');
  • Liste des objets d'un user particulier
SELECT DISTINCT owner, tablespace_name FROM dba_segments WHERE owner IN ('xxx');
Création user et grant sur un autre schéma

–create user R2D2_READ_ONLY_USER identified by “r2d2_2024”; grant CONNECT to R2D2_READ_ONLY_USER ; alter user R2D2_READ_ONLY_USER profile TAFJ_PROFILE;

BEGIN 

 FOR R IN (SELECT owner, object_name FROM dba_objects WHERE owner='R2D2USER' and object_type in ('TABLE','VIEW')) 
  LOOP
    EXECUTE IMMEDIATE 'grant select on '||R.owner||'.'||R.object_name||' to R2D2_READ_ONLY_USER ';
    EXECUTE IMMEDIATE 'CREATE OR REPLACE SYNONYM T24_READ_ONLY_USER.' || R.object_name || ' FOR ' || R.owner || '.' || R.object_name;
 END LOOP;

END; /