Home » Server Options » Streams & AQ » dbms_rule_adm problem
dbms_rule_adm problem [message #75729] Wed, 28 July 2004 04:42 Go to next message
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 Go to previous message
Frank Naude
Messages: 4410
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
Previous Topic: SUPPLEMENTAL LOG DATA
Next Topic: streams for warehousing
Goto Forum:
  


Current Time: Sun Apr 20 11:44:47 CDT 2014

Total time taken to generate the page: 0.09321 seconds