No question at this time
DBA Top 10
1 M. Cadot 7000
2 B. Vroman 3000
3 P. Wisse 1300
4 P. Tsongayinwe 1100
5 J. PĂ©ran 1000
6 A. Kavsek 600
7 D. Walgude 400
7 J. Schnackenberg 400
9 J. Alcroft 200
9 B. M 200
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48717
Total active users1324
Act. users last 24h1
Act. users last hour0
Registered user hits last week17
Registered user hits last month178
Go up

ALTER SYSTEM work for ordinary users
Next thread: Exhausted Resultset
Prev thread: Keyword to find the DB issue

Message Score Author Date
Dear All, Observing strange behavior ALTER SYST...... dattatraya walgude Dec 02, 2022, 09:58
Check the privileges granted to PUBLIC. Regar...... Score: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 Pts Michel Cadot Dec 02, 2022, 10:08
Michel, I really appreciate all the solutions and...... dattatraya walgude Dec 02, 2022, 10:46

Follow up by mail Click here


Subject: ALTER SYSTEM work for ordinary users
Author: dattatraya walgude, India
Date: Dec 02, 2022, 09:58, 68 days ago
Os info: RHEL
Oracle info: Database 12c Release 12.1.0.1.0 - 64bit Production
Message: Dear All,

Observing strange behavior ALTER SYSTEM work for ordinary users who has only create session privilege.


<>SQL> drop user U cascade;

User dropped.

SQL> show user
USER is "SYS"
SQL> create user U identified by P;

User created.

SQL> grant create session to U;

Grant succeeded.

SQL> conn U/P
Connected.
SQL> show user;
USER is "U"
SQL> alter system set job_queue_processes=100;

System altered.

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

Subject: Re: ALTER SYSTEM work for ordinary users
Author: Michel Cadot, France
Date: Dec 02, 2022, 10:08, 68 days ago
Score:   Score: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 Pts
Message:
Check the privileges granted to PUBLIC.

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

Subject: Re: ALTER SYSTEM work for ordinary users
Author: dattatraya walgude, India
Date: Dec 02, 2022, 10:46, 68 days ago
Message: Michel,
I really appreciate all the solutions and suggestions you provide.

ALTER SYSTEM was given to PUBLIC !!!!!

<>SQL> revoke alter system from public;

Revoke succeeded.

SQL> conn u/p
Connected.
SQL> show user;
USER is "U"
SQL> alter system set job_queue_processes=100;
alter system set job_queue_processes=100
*
ERROR at line 1:
ORA-01031: insufficient privileges


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