No question at this time
DBA Top 10
1 A. Kavsek 8600
2 M. Cadot 7200
3 B. Vroman 6200
4 T. Boles 4550
5 J. Schnackenberg 4100
6 P. Wisse 3200
7 T. P 1200
8 G. Lambregts 1100
8 . Lauri 1100
10 R. Pattyn 800
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48373
Total active users1542
Act. users last 24h7
Act. users last hour0
Registered user hits last week192
Registered user hits last month1051
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, 92 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, 92 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, 92 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, 92 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, 92 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