Tuesday, June 9, 2009

Check table permissions

Use this script to verify that the users have enough permissions on your table.
The privileges may be: SELECT, INSERT, UPDATE, DELETE

SELECT
*
FROM DBA_TAB_PRIVS
WHERE TABLE_NAME = 'Your table name';

No comments:

Post a Comment

Oracle Query