No question at this time
DBA Top 10
1 A. Kavsek 8700
2 B. Vroman 5900
3 M. Cadot 5400
4 P. Wisse 4800
5 T. Boles 3700
6 J. Schnackenberg 2100
7 . Lauri 1500
8 R. Pattyn 700
9 T. P 600
9 J. PĂ©ran 600
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48409
Total active users1518
Act. users last 24h5
Act. users last hour0
Registered user hits last week284
Registered user hits last month997
Go up

Update privileges
Next thread: For-loop with dynamic SQL
Prev thread: PL/SQL packages and Tuning Pack

Message Score Author Date
Hi Stupid question, and I don't know the soluti...... James Alcroft Feb 18, 2019, 19:03
Hi, Can you please post the results of the belo...... Lauri Feb 19, 2019, 09:07
Hi, > How do I fix this problem? grant sele...... Ales Kavsek Feb 19, 2019, 09:23
Hi, and if you wonder why...default value for s...... Score: 600 PtsScore: 600 PtsScore: 600 PtsScore: 600 PtsScore: 600 Pts Ales Kavsek Feb 19, 2019, 09:57
Thanks for all the response. I have granted SEL...... James Alcroft Feb 19, 2019, 11:01

Follow up by mail Click here


Subject: Update privileges
Author: James Alcroft, United Kingdom
Date: Feb 18, 2019, 19:03, 185 days ago
Os info: Win 2012
Oracle info: 12.2
Message: Hi

Stupid question, and I don't know the solution for this.

I have issued the following:

grant update on hum.sys_options to global;

If I login as global, and issue the following:

update hum.sys_options set value='21' where name='VERSION';

I get ORA_01031: insufficient privileges error.

12.2 is our dev database, our production database is still at 12.1, and issue the above statements on 12.1, everything works.

Is there some difference between 12.1 and 12.2 that I have missed regarding privileges? How do I fix this problem?

Many thanks.

James
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re-Update privileges
Author: Lauri, Netherlands
Date: Feb 19, 2019, 09:07, 184 days ago
Message: Hi,

Can you please post the results of the below code executed in SQL*PLus:

connect hum/password@database_service
show user
grant update on hum.sys_options to global;
connect global/password@database_service
show user
update hum.sys_options set value='21' where name='VERSION';

What result do you get:

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

Subject: Re: Update privileges
Author: Ales Kavsek, Slovenia
Date: Feb 19, 2019, 09:23, 184 days ago
Message: Hi,

> How do I fix this problem?

grant select on hum.sys_options to global;

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

Subject: Re: Update privileges
Author: Ales Kavsek, Slovenia
Date: Feb 19, 2019, 09:57, 184 days ago
Score:   Score: 600 PtsScore: 600 PtsScore: 600 PtsScore: 600 PtsScore: 600 Pts
Message: Hi,

and if you wonder why...default value for system parameter SQL92_SECURITY changed in 12.2 from false to true.


https://docs.oracle.com/en/database/oracle/oracle-database/12.2/refrn/SQL92_SECURITY.html#GUID-E41087C2-250E-4201-908B-79E659B22A4B

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

Subject: Re: Update privileges
Author: James Alcroft, United Kingdom
Date: Feb 19, 2019, 11:01, 184 days ago
Message: Thanks for all the response.

I have granted SELECT on sys_options which now allows me to update this table.

Must be one of the security changes between 12.1 to 12.2 as Ales pointed to.

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