-
Hi all,
We have TOAD and another reporting application on our database.
Few users have access to TOAD and we are concerned that they might delete or drop a table in the database. All of the users were created in the reporting application which only read, write and delete privilege. How can we enhance the databsae security through
toad or ?
Any suggestion?
Thanks
Arsene Lupain
The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.
-
As you mentioned reporting application then I assume that the users do not need insert, update, delete privileges. You may revoke them and just make sure that the select privilege is granted on the tables, views.
Or you may create a role for reporting application and grant it to the application users.
Sanjay
-
Arsene Lupain
The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.
-
TOAD also has security within itself.
Tools -> Toad Security
If you need more detail e-mail me at
eric.yen@quest.com
E. Yen
OCP DBA 8, 8i, 9i
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
|