Home » RDBMS Server » Security » Oracle 11g DBMS_SQL Security (Oracle 11g)
Oracle 11g DBMS_SQL Security [message #279157] Wed, 07 November 2007 02:51 Go to next message
Oyunbold
Messages: 21
Registered: September 2007
Location: MGL
Junior Member
I can't open cursors.
How to disable _dbms_sql_security_level
Help me
Re: Oracle 11g DBMS_SQL Security [message #279236 is a reply to message #279157] Wed, 07 November 2007 07:53 Go to previous messageGo to next message
Frank Naude
Messages: 4579
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
Re: Oracle 11g DBMS_SQL Security [message #279248 is a reply to message #279236] Wed, 07 November 2007 08:24 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In addition, "1" is the default value.

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


Current Time: Thu Mar 28 20:15:33 CDT 2024