Per veure els rols d’un usuari
SQL
SELECT GRANTEE, GRANTED_ROLE, ADMIN_OPTION, DEFAULT_ROLE
FROM DBA_ROLE_PRIVS
WHERE GRANTEE = UPPER('PRODUCCIO');Per veure els privilegis d’un usuari
SQL
ELECT OWNER, TABLE_NAME, PRIVILEGE, GRANTABLE
FROM DBA_TAB_PRIVS
WHERE GRANTEE = UPPER('PRODUCCIO')
ORDER BY OWNER, TABLE_NAME;Diversos comandament per assignar rols i privilegis
SQL
GRANT SELECT, INSERT, UPDATE, DELETE ON PRODUCCIO.FYM_NOTIFICACIONS TO CURTITS;
GRANT RESOURCE TO PRODUCCIO;
ALTER USER PRODUCCIO QUOTA UNLIMITED ON USERS;
ALTER USER PRODUCCIO DEFAULT ROLE CONNECT, RESOURCE;