DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: reg privileges -- asap

  1. #1
    Join Date
    May 2002
    Posts
    6
    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

  2. #2
    Join Date
    Jan 2002
    Posts
    148
    why dont u use roles???

  3. #3
    Join Date
    Apr 2002
    Posts
    7
    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

  4. #4
    Join Date
    Mar 2002
    Posts
    301
    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
  •  


Click Here to Expand Forum to Full Width