User Rights
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: User Rights

  1. #1
    Join Date
    Oct 2000
    Posts
    24
    I have created a user using security manager. I need this user to be only view tables. What is the minimum permission that I need to assgin to this user

    Thanks

  2. #2
    Join Date
    Feb 2001
    Location
    Bangalore, India
    Posts
    109
    If you create a user using security manager. that user is granted CONNECT role by default. Revoke it. Grant the privileges CREATE SESSION & SELECT ANY TABLE.

  3. #3
    Join Date
    Feb 2001
    Posts
    119
    if you want to view only V$ views then grant create session and select_catalog_role ..

    that will do.

  4. #4
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    IT would be a good practice to grant the select option on the tables that you want the user to be allowed to view. This way, you have a very good access control set up rather than being generous and getting into problems.

    Always be presice in grating the access to the users, it would be a good practice.

    I hope I'm not being rude in pointing this out, which I have notice being a problem among many of us. I was also one among this group some times back :)

    Good luck,
    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  5. #5
    Join Date
    Nov 2000
    Posts
    57
    Granting this(just giving create any session)permission will in turn grant the user to drop any table...which is created by system user.. check it out...

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