betweenGo

SQL> select privilege from user_tab_privs where lower(table_name)=’t_foo’ and lower(grantee)=’frank’;

PRIVILEGE
—————————————-
UPDATE
SELECT
INSERT
DELETE

SQL> select * from user_role_privs;

USERNAME GRANTED_ROLE ADM DEF OS_
—————————— —————————— — — —
FRANK AQ_ADMINISTRATOR_ROLE NO YES NO
PUBLIC SELECT_CATALOG_ROLE NO YES NO

Related posts:

1. Listing All Tables
2. SQL Insert in One Table Based on Values in Another Table
3. Inserting a text value with special characters
4. Updating/Reading Dates
5. SQL Update in One Table Based on Values in Another Table