OraFAQ Forum: Programming Interfaces » alter session set "_ORACLE

Home » Open Source » Programming Interfaces » alter session set "_ORACLE_SCRIPT"=true -> insufficient privileges (Oracle 12.2)

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

alter session set "_ORACLE_SCRIPT"=true -> insufficient privileges [message #675306]

Thu, 21 March 2019 13:17

a100
Messages: 34
Registered: March 2019

Member

Hello,
forgive my ignorance - I am total noob with Oracle ...

I have just created Oracle 12.2 in AWS for dev/testing purposes and connected to it using the admin account.
I am trying to run the following:

alter session set "_ORACLE_SCRIPT"=TRUE
create user ...

but gets the following error - does anybody know why ?

Reason:
SQL Error [2097] [42000]: ORA-02097: parameter cannot be modified because specified value is invalid
ORA-01031: insufficient privileges

Report message to a moderator

[Message index]

		alter session set "_ORACLE_SCRIPT"=true -> insufficient privileges By: a100 on Thu, 21 March 2019 13:17
		Re: alter session set "_ORACLE_SCRIPT"=true -> insufficient privileges By: Michel Cadot on Thu, 21 March 2019 13:51
		Re: alter session set "_ORACLE_SCRIPT"=true -> insufficient privileges By: a100 on Thu, 21 March 2019 15:05
		Re: alter session set "_ORACLE_SCRIPT"=true -> insufficient privileges By: Michel Cadot on Thu, 21 March 2019 15:14
		Re: alter session set "_ORACLE_SCRIPT"=true -> insufficient privileges By: John Watson on Thu, 21 March 2019 15:28
		Re: alter session set "_ORACLE_SCRIPT"=true -> insufficient privileges By: a100 on Thu, 21 March 2019 15:42
		Re: alter session set "_ORACLE_SCRIPT"=true -> insufficient privileges By: Michel Cadot on Thu, 21 March 2019 15:52
		Re: alter session set "_ORACLE_SCRIPT"=true -> insufficient privileges By: Michel Cadot on Thu, 21 March 2019 15:39
		Re: alter session set "_ORACLE_SCRIPT"=true -> insufficient privileges By: a100 on Thu, 21 March 2019 15:52
		Re: alter session set "_ORACLE_SCRIPT"=true -> insufficient privileges By: Michel Cadot on Thu, 21 March 2019 15:53
		Re: alter session set "_ORACLE_SCRIPT"=true -> insufficient privileges By: a100 on Thu, 21 March 2019 15:57
		Re: alter session set "_ORACLE_SCRIPT"=true -> insufficient privileges By: Michel Cadot on Fri, 22 March 2019 01:57
		Re: alter session set "_ORACLE_SCRIPT"=true -> insufficient privileges By: a100 on Fri, 22 March 2019 03:52
		Re: alter session set "_ORACLE_SCRIPT"=true -> insufficient privileges By: John Watson on Fri, 22 March 2019 03:58
		Re: alter session set "_ORACLE_SCRIPT"=true -> insufficient privileges By: Michel Cadot on Fri, 22 March 2019 04:06
		Re: alter session set "_ORACLE_SCRIPT"=true -> insufficient privileges By: a100 on Fri, 22 March 2019 05:28
		Re: alter session set "_ORACLE_SCRIPT"=true -> insufficient privileges By: a100 on Fri, 22 March 2019 05:47
		Re: alter session set "_ORACLE_SCRIPT"=true -> insufficient privileges By: John Watson on Fri, 22 March 2019 05:52
		Re: alter session set "_ORACLE_SCRIPT"=true -> insufficient privileges By: a100 on Fri, 22 March 2019 05:59
		Re: alter session set "_ORACLE_SCRIPT"=true -> insufficient privileges By: John Watson on Fri, 22 March 2019 06:02
		Re: alter session set "_ORACLE_SCRIPT"=true -> insufficient privileges By: a100 on Fri, 22 March 2019 06:12
		Re: alter session set "_ORACLE_SCRIPT"=true -> insufficient privileges By: John Watson on Fri, 22 March 2019 06:18
		Re: alter session set "_ORACLE_SCRIPT"=true -> insufficient privileges By: a100 on Fri, 22 March 2019 06:34
		Re: alter session set "_ORACLE_SCRIPT"=true -> insufficient privileges By: John Watson on Fri, 22 March 2019 07:02
		Re: alter session set "_ORACLE_SCRIPT"=true -> insufficient privileges By: a100 on Fri, 22 March 2019 07:39
		Re: alter session set "_ORACLE_SCRIPT"=true -> insufficient privileges By: BlackSwan on Fri, 22 March 2019 08:05
		Re: alter session set "_ORACLE_SCRIPT"=true -> insufficient privileges By: a100 on Fri, 22 March 2019 08:10
		Re: alter session set "_ORACLE_SCRIPT"=true -> insufficient privileges By: BlackSwan on Fri, 22 March 2019 10:18
		Re: alter session set "_ORACLE_SCRIPT"=true -> insufficient privileges By: John Watson on Fri, 22 March 2019 10:43
		Re: alter session set "_ORACLE_SCRIPT"=true -> insufficient privileges By: a100 on Fri, 22 March 2019 10:56
		Re: alter session set "_ORACLE_SCRIPT"=true -> insufficient privileges By: John Watson on Fri, 22 March 2019 11:30

Previous Topic:	SQL query returning wrong values
Next Topic:	Looking for more information about a bug

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 14:22:54 CDT 2024