Database Administration (MOSC)

MOSC Banner

Trigger issue

edited Aug 2, 2010 2:10AM in Database Administration (MOSC) 2 commentsAnswered
I have a user that only should grant specific ROLES to other users.

I created a trigger in order to restrict AFTER GRANT event but I am getting the following error: “ORA-00406: COMPATIBLE parameter needs to be 8.1.6.0.0 or greater”

Running :
select value from v$parameter where name ='compatible';
I got: 8.1.0
But I am not sure if I should change it and which is the recommended procedure.   (QUESTION 1)

The trigger is:

CREATE or REPLACE TRIGGER prohibit_grant_SAUABC
BEFORE GRANT on SAUABC.schema
BEGIN
IF ora_sysevent='GRANT' and ora_dict_obj_type = 'ROLE'
THEN
RAISE_APPLICATION_ERROR(-20005,'You are not allowed to grant this role');

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center