Home » SQL & PL/SQL » SQL & PL/SQL » Query for RLS is not activated: (oracle 10g)
Query for RLS is not activated: [message #419668] Tue, 25 August 2009 00:16 Go to next message
deep0983
Messages: 28
Registered: April 2009
Junior Member
Hi All

can anybody tell me what should be the query for checking whether RLS is not active.

regards
deepak
Re: Query for RLS is not activated: [message #419669 is a reply to message #419668] Tue, 25 August 2009 00:21 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.

>can anybody tell me what should be the query for checking whether RLS is not active.

RLS? Row Level Security?
Re: Query for RLS is not activated: [message #419671 is a reply to message #419669] Tue, 25 August 2009 00:29 Go to previous messageGo to next message
deep0983
Messages: 28
Registered: April 2009
Junior Member
Yes RLS Means ROW LEVEL SECURITY.
Re: Query for RLS is not activated: [message #419672 is a reply to message #419668] Tue, 25 August 2009 00:39 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
V$VPD_POLICY

Regards
Michel
Re: Query for RLS is not activated: [message #419675 is a reply to message #419668] Tue, 25 August 2009 00:41 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
DBA_POLICIES

Regards
Michel
Re: Query for RLS is not activated: [message #419677 is a reply to message #419675] Tue, 25 August 2009 02:06 Go to previous message
deep0983
Messages: 28
Registered: April 2009
Junior Member
Thanks a lot Michel
Previous Topic: Please Help in Pivot Query
Next Topic: ORA00604: error occurred at recursive SQL Level 1 ORA01400: can not insert null in to (sys,obj$,name
Goto Forum:
  


Current Time: Tue Feb 11 13:35:54 CST 2025