dbms_rule_adm problem [message #75729] |
Wed, 28 July 2004 04:42 |
Tugrul
Messages: 2 Registered: July 2004
|
Junior Member |
|
|
Hi, I am trying to configure streams. I have Oracle9i Enterprise Edition Release 9.2.0.5. I am walking through some Oracle document and I did the following.
-Set the initialization parameters for database
-connected with sys as sysdba
-created streams admin user(with his tablespace)
-execute the following commands
GRANT EXECUTE ON DBMS_AQADM TO strmadmin;
GRANT EXECUTE ON DBMS_CAPTURE_ADM TO strmadmin;
GRANT EXECUTE ON DBMS_PROPAGATION_ADM TO strmadmin;
GRANT EXECUTE ON DBMS_STREAMS_ADM TO strmadmin;
BEGIN
DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(
privilege => DBMS_RULE_ADM.CREATE_RULE_SET_OBJ,
grantee => 'strmadmin',
grant_option => FALSE);
END;
/
grants worked well but in the last begin-end block I got the following error:
ERROR at line 1:
ORA-00931: missing identifier
ORA-24000: invalid value name, name should be of the form , USER/ROLE [[SCHEMA.]]NAME
ORA-06512: "SYS.DBMS_RULE_ADM", line 167
ORA-06512: line 2
I tried putting SYS to both dbms_rule_adm commands but the error went on.
In another forum, someone suggested executing the following procedure before the erroneous one:
BEGIN
DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(
privilege => DBMS_RULE_ADM.CREATE_EVALUATION_CONTEXT_OBJ,
grantee => 'STRMADMIN',
grant_option => TRUE);
end;
/
When I execute this, I get :
ERROR at line 1:
ORA-03113: end-of-file on communication channel
error message and I stopped trying.
I just try to prepare a user to use streams, I think it must be easier. I really need experinced people's help a lot...
Thanks
|
|
|
Re: dbms_rule_adm problem [message #75733 is a reply to message #75729] |
Thu, 12 August 2004 05:26 |
Frank Naude
Messages: 4581 Registered: April 1998
|
Senior Member |
|
|
Hi,
The problem is not with the command you've entered, but with your database. You may want to try it on a different database:
SQL> create user strmadmin IDENTIFIED BY manager;
User created.
SQL> BEGIN
DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE(
privilege => DBMS_RULE_ADM.CREATE_RULE_SET_OBJ,
grantee => 'strmadmin',
grant_option => FALSE);
END;
/ 2 3 4 5 6 7
PL/SQL procedure successfully completed.
SQL>
Best regards.
Frank
|
|
|