Database Security Products (MOSC)

MOSC Banner

Insert Privilege not working if select Privilege not granted

edited Sep 4, 2013 12:00AM in Database Security Products (MOSC) 5 commentsAnswered ✓
Hi,
     I need to insert a record in to a remote database table  using a DB link with user having only insert privilege, not having select privilege(The DB link has been created by the user on the remote database
having only insert privilege to the the table concerned).
but it is not working without select privilege. If select privilege granted then insert is working.
What might be the reason? how can resolve this issue?


WIth Regards
Naseer

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center