No question at this time
DBA Top 10
1 M. Cadot 6500
2 B. Vroman 2700
3 J. PĂ©ran 1600
4 P. Tsongayinwe 1500
5 P. Wisse 1200
6 A. Kavsek 1100
7 D. Walgude 400
7 J. Schnackenberg 400
9 J. Alcroft 200
10 A. Hudspith 100
10 D. Johnson 100
10 B. B 100
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48695
Total active users1320
Act. users last 24h0
Act. users last hour0
Registered user hits last week12
Registered user hits last month347
Go up

Invalid Privilege
Next thread: ora 01031 error-insufficient privileges
Prev thread: How to follow the growth of your database

Message Score Author Date
There is a requirement where we have to change all...... Shalabh Mehrotra Jan 19, 2004, 14:06
MDSYS user is created as the owner of spatial opti...... Kailash Hingorani Jan 19, 2004, 15:23
Dear Shablah Such priviege does not revoke usin...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Madhukar Srivastava Jan 21, 2004, 17:12
I am sorry that I have to bother you.I execute th...... yiji wei Jan 28, 2004, 05:28

Follow up by mail Click here


Subject: Invalid Privilege
Author: Shalabh Mehrotra, India
Date: Jan 19, 2004, 14:06, 6833 days ago
Os info: Win2K
Oracle info: 9i
Error info: ORA-00990: missing or invalid privilege

But these are valid privileges as could be seen from DBA_SYS_PRIVS table. What's happening here? Any clues.
Message: There is a requirement where we have to change all the system privileges granted with WITH GRANT OPTION other than for SYS and SYSTEM. We were able to revoke and re-grant without WITH GRANT OPTION all of them except few

Querying DBA_SYS_PRIVS gives the result -

select * from DBA_SYS_PRIVS s
where s.admin_option = 'YES'
and s.GRANTEE not in ('SYS','SYSTEM')

GRANTEE PRIVILEGE ADMIN_OPTION
1 MDSYS CREATE RULE YES
2 MDSYS DROP ANY RULE YES
3 MDSYS ALTER ANY RULE YES
4 MDSYS CREATE ANY RULE YES
5 MDSYS CREATE RULE SET YES
6 MDSYS EXECUTE ANY RULE YES
7 MDSYS MANAGE ANY QUEUE YES
8 MDSYS DEQUEUE ANY QUEUE YES
9 MDSYS DROP ANY RULE SET YES
10 MDSYS ENQUEUE ANY QUEUE YES
11 MDSYS ALTER ANY RULE SET YES
12 MDSYS CREATE ANY RULE SET YES
13 MDSYS EXECUTE ANY RULE SET YES
14 MDSYS CREATE EVALUATION CONTEXT YES
15 MDSYS ADMINISTER RESOURCE MANAGER YES
16 MDSYS DROP ANY EVALUATION CONTEXT YES
17 MDSYS ALTER ANY EVALUATION CONTEXT YES
18 MDSYS CREATE ANY EVALUATION CONTEXT YES
19 MDSYS EXECUTE ANY EVALUATION CONTEXT YES

revoke CREATE RULE from MDSYS;
gives the message
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Invalid Privilege
Author: Kailash Hingorani, United States
Date: Jan 19, 2004, 15:23, 6833 days ago
Message: MDSYS user is created as the owner of spatial option, if you are not using spatial you can drop/lock mdsys user

HtH
-kailash

Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Invalid Privilege
Author: Madhukar Srivastava, India
Date: Jan 21, 2004, 17:12, 6831 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message: Dear Shablah

Such priviege does not revoke using normal revoke procedure. U have to use packaged procedure e.g. I did for 'CREATE ANY RULE'

SQL>
SQL>
SQL>
SQL> BEGIN
2 DBMS_RULE_ADM.REVOKE_SYSTEM_PRIVILEGE (
3 DBMS_RULE_ADM.CREATE_ANY_RULE, 'MDSYS') ;
4 END ;
5 /

PL/SQL procedure successfully completed.

Let me know if u have any other problem in this

Regards

Madhukar


SQ
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Re: Invalid Privilege
Author: yiji wei, China
Date: Jan 28, 2004, 05:28, 6824 days ago
Message: I am sorry that I have to bother you.I execute the script like yours.but it returns these errors:
ERROR 位于第 3 行:
ORA-06550: 第 3 行, 第 15 列:
PLS-00302: 必须说明 'CREATE_ANY_RULE' 组件
ORA-06550: 第 2 行, 第 1 列:
PL/SQL: Statement ignored

But I don't how to deal with it .can you tell me how to do next?
Thanks very much.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here