Realms : It is defined as boundary or protection zone around application data.
Click on "Create" and provide the appropriate Name and Description.
Click "Ok"-> Select new "Realm" and Click on "Edit" .
Use the drop-down list to select the owner,object type and enter the object name.
To restrict access to an entire schema,leave the " % " in the object name field.
Click ok
Now , if we try to query then it will return ORA-01031: insufficient privileges
Click on "Create" and provide the appropriate Name and Description.
Click "Ok"-> Select new "Realm" and Click on "Edit" .
To restrict access to an entire schema,leave the " % " in the object name field.
Click ok
Now , if we try to query then it will return ORA-01031: insufficient privileges
1 comments:
Nice post thanks
kajal hot
Post a Comment