PROMPT verify if the given user has privilege to the given table via a role
SELECT ROLE,OWNER, TABLE_NAME,COLUMN_NAME,PRIVILEGE
FROM ROLE_TAB_PRIVS
WHERE OWNER='&OWNER'
AND TABLE_NAME='&TABLENAME'
Hosted by www.Geocities.ws

1