Validate User Privileges Script For Oracle

Go Up to Main Page

Script For Validate User Privileges in Oracle

This script will validate user privileges and show the system privileges of the user Note, you will need to change the user from 'ERSTUDIO' to the one you created earlier in the installation process.

select GRANTEE ,

PRIVILEGE ,

ADMIN_OPTION ,

COMMON ,

INHERITED from DBA_SYS_PRIVS

where grantee = 'ERSTUDIO';

It should return results that look like this

GRANTEE	PRIVILEGE	ADMIN_OPTION	COMMON	INHERITED
ERSTUDIO	CREATE TABLE	NO	NO	NO
ERSTUDIO	CREATE TYPE	NO	NO	NO
ERSTUDIO	CREATE VIEW	NO	NO	NO
ERSTUDIO	CREATE INDEXTYPE	NO	NO	NO
ERSTUDIO	CREATE PROCEDURE	NO	NO	NO
ERSTUDIO	UNLIMITED TABLESPACE	NO	NO	NO
ERSTUDIO	CREATE SESSION	NO	NO	NO
ERSTUDIO	CREATE SEQUENCE	NO	NO	NO
ERSTUDIO	CREATE TRIGGER	NO	NO	NO
ERSTUDIO	CREATE SYNONYM	NO	NO	NO