-
Limit db access to users using Access or Toad
Here is what I want to do -
When users login to the db using Microsoft Access or Toad, I want to make the data readonly for them.
Here is what I tried doing -
1. Created a role with a readonly privilege. Assign the role using dbms_session.set_role in a logon trigger
2. Created a user with readonly access to the db. Issued a alter session set_current_schema to the new user
The first approach did not work because we cannot set role in a trigger. The second option did not work because it only changed the user's context. It did not change the privileges.
Any other ideas that I can try? Thanks!
Last edited by chikkodi; 08-23-2006 at 12:24 PM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|