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

Thread: Creat a User

  1. #1
    Join Date
    Mar 2001
    Posts
    109

    Question

    How can I create a user who can only access his own schema? Can any body let me know the script for this?

    Thanks.
    zm

  2. #2
    Join Date
    Feb 2001
    Posts
    184
    Unless you give him other Priviliges, he will have his own schema access.

    Thanks

  3. #3
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530
    Hi,
    Dont give him select any table system privilege.If u give that user select any table system privilege he can select from any schema also from SYS,if ur init.ora parameter
    O7_dictionary_accessibilty=TRUE.
    Also dont give him exclusive object privielege to select from other schema tables.
    In case of any problems please be free to write to me at rohitsn@altavista.com

    Regards,
    Rohit Nirkhe
    Oracle DBA,OCP
    rohitsn@altavista.com

  4. #4
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Well, strictly speaking, you can't make a user that can access only his own schema. All users have also access to objects granted to schema PUBLIC and there is no way you can prevent this. So if you create a user that has only CREATE SESSION privilege (is only able to connect to database, nothing else), he will still be able to select from DUAL, USER_* views etc etc...
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  5. #5
    Join Date
    Aug 2000
    Posts
    462
    create user mynewuser identified by mynewuserpwd (put storage parameters here);
    grant create session to mynewuser;

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