OraFAQ Forum: Security » Oracle 11g DBMS

Home » RDBMS Server » Security » Oracle 11g DBMS_SQL Security (Oracle 11g)

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

Oracle 11g DBMS_SQL Security [message #279157]

Wed, 07 November 2007 02:51

Oyunbold
Messages: 21
Registered: September 2007
Location: MGL

Junior Member

I can't open cursors.
How to disable _dbms_sql_security_level
Help me

Report message to a moderator

Re: Oracle 11g DBMS_SQL Security [message #279236 is a reply to message #279157]

Wed, 07 November 2007 07:53

Frank Naude
Messages: 4596
Registered: April 1998

Senior Member

You can set the SECURITY_LEVEL when opening a cursor (DBMS_SQL.OPEN_CURSOR).

To change it system wide, set _dbms_sql_security_level in your init.ora or SPFILE.

Values:
0=no checks
1=bind and execute user must be same as parse user
2=user for all operations must be the same

Report message to a moderator

Re: Oracle 11g DBMS_SQL Security [message #279248 is a reply to message #279236]

Wed, 07 November 2007 08:24

Michel Cadot
Messages: 68756
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

In addition, "1" is the default value.

Regards
Michel

Report message to a moderator

Previous Topic:	How to set Destination file for AUDIT_TRAIL=OS
Next Topic:	Oracle installation groups and permissions

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 07 11:00:55 CDT 2025