OraFAQ Forum: Streams & AQ » dbms_rule

Home » Server Options » Streams & AQ » dbms_rule_adm problem

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

Re: dbms_rule_adm problem [message #75733 is a reply to message #75729]

Thu, 12 August 2004 05:26

Frank Naude
Messages: 4579
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

Report message to a moderator

Previous Topic:	SUPPLEMENTAL LOG DATA
Next Topic:	streams for warehousing

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 00:46:09 CDT 2024