Sneak in as another user
- Sneak in as another user if you have the alter user privilege. This script creates reset.sql which can be executed to reset the password to the old one.
pop
(Added: 29-Aug-1999 Hits: 10482 Rating: 2.82 Votes: 21) Rate It
Create user with random password
- This script is useful for when you want to create a user with a random password.
(Added: 19-Mar-2004 Hits: 3856 Rating: 0 Votes: 0) Rate It
Setup Row Level Security or Virtual Private Database
- This functionality to support fine-grained access control is based on dynamic predicates, where security rules are not embedded in views, but are acquired at the statement parse time, when the base table or view is referenced in a DML statement.
A dynamic predicate for a table or view is generated by a PL/SQL function, which is associated with a security policy through a PL/SQL interface.
Whenever Target_Table is referenced in a query or subquery (SELECT), the server calls the GetLabel function. This returns a predicate specific to the current user for the SECURITY_POLICY policy.
(Added: 23-Apr-2004 Hits: 2749 Rating: 0 Votes: 0) Rate It
