0

Oracle 11.2.0.3

My instructions are

DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(DBMS_RULE_ADM.CREATE_RULE_OBJ, '<schema_name>');

I tried to run them at sqlplus /as sysdba

but it tells me unknown command beginning DBMS_RULE

Is there a different way to run these?

0

1 Answer 1

3

You need to use EXEC[UTE] or BEGIN ... END ;.

EXEC DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(DBMS_RULE_ADM.CREATE_RULE_OBJ, '');

Or:

BEGIN
  DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(DBMS_RULE_ADM.CREATE_RULE_OBJ, '');
END;
/
0

Not the answer you're looking for? Browse other questions tagged or ask your own question.