Simple Oracle, MS SQL, Postgres, AWS and more
Oracle
SQL Server
PostgreSQL
MySQL
Linux
Windows
AWS
DevOps
Tuesday, November 12, 2013
Find roles granted to users start with "X" or "T" following by any number
select grantee, GRANTED_ROLE
from dba_role_privs
where REGEXP_LIKE(GRANTEE, '^[X|T][0-9]+$')order by grantee;
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment