- Background: (46, 46, 46); #2e2e2e
- Comments: (121, 121, 121); #797979
- White: (214, 214, 214); #d6d6d6
- Yellow: (229, 181, 103); #e5b567
- Green: (180, 210, 115); #b4d273
- Orange: (232, 125, 62); #e87d3e
- Purple: (158, 134, 200); #9e86c8
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"AL": "Alabama", | |
"AK": "Alaska", | |
"AS": "American Samoa", | |
"AZ": "Arizona", | |
"AR": "Arkansas", | |
"CA": "California", | |
"CO": "Colorado", | |
"CT": "Connecticut", | |
"DE": "Delaware", |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- See what has access to a particular table (direct and inherited): | |
select Grantee,'Granted Through Role' as Grant_Type, role, table_name | |
from role_tab_privs rtp, dba_role_privs drp | |
where rtp.role = drp.granted_role | |
and table_name = :tablename | |
union | |
select Grantee,'Direct Grant' as Grant_type, null as role, table_name | |
from dba_tab_privs | |
where table_name = :tablename; |
OlderNewer