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

Thread: Create User

  1. 07-25-2001, 09:16 AM #1
    djaxe
    djaxe is offline Junior Member
    Join Date
    Jul 2001
    Posts
    1

    Angry

    Hello....Help Me please........
    Oracle 8: How, can I create one user that can read only one table on my database and other user that can write only one table?
    Tanks!!
    Reply With Quote Reply With Quote
  2. 07-25-2001, 09:23 AM #2
    shadow21
    shadow21 is offline Locally self-managed
    Join Date
    Apr 2001
    Posts
    107
    Hi,

    1- Just create a user, grant him the 'connect' role, and them grant him 'select on owner.table'...
    2 - same thing with 'grant insert into owner.table'

    I suggest you use roles, which can be useful if you plan to have other users with same privileges.
    You can them grant these roles to future users...

    Hope it helps

    Cheers

    Fabien
    Reply With Quote Reply With Quote
  3. 07-25-2001, 09:24 AM #3
    cvd123
    cvd123 is offline Junior Member
    Join Date
    Jul 2001
    Posts
    56
    just create one table in that user
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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