-
Hello
I have question regarding privileges
It is basically ,i want to restrict people from using
ddl -- create ,alter ,drop
dml -insert update and delete .
I should give only select statement for some of them .
I am using toad(quest software ) ,is there any way i can restrict on tad or by granting privileges .
Onemore thing is ,we have built in software taod with our system ,when people log in they can get directly connected to database by clinking the toad option .
what way i can restrict the user from the above options
Thanks in advance
-
-
Normally a common user should only have the system privilege "create session". So now DDL can be done. DML privileges are given through roles consisting of privileges of a schema holder and granted to an user.
I think that the use of TOAD should be done at NT level by setting a specific group for an user.
regards
-
Hi,
Create the user's and grant them only the CREATE SESSION privilege.
Create a role, to which you grant the required privileges and inturn grant these roles to the users.
Vijay.
Say No To Plastics
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
|