Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2003
    Posts
    28

    Unanswered: Allow other User to create tables and view in a same single Schema

    hi

    i have to create a new schema in my Oracle database and allow 4 users to create tables and views in this new schema passing through by their owner users ...
    Can i do this , and how ??

    Thanks 4 the reply !!

    Bye

    Sidnet

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296

    Re: Allow other User to create tables and view in a same single Schema

    Originally posted by Sidnet
    hi
    i have to create a new schema in my Oracle database and allow 4 users to create tables and views in this new schema passing through by their owner users ...
    Can i do this , and how ??
    Thanks 4 the reply !!
    Bye
    Sidnet
    set the default schema for the 4 users to the new shema.
    give them the create table and select privs on that schema
    or create a role and assign to each user.

    if you do not set their default schema to the new schema, then
    when they create tables they should specify the new schema to
    create in.

    example: create table schema_name.table_name as select * from emp;
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  3. #3
    Join Date
    Feb 2004
    Posts
    20
    you used the sentance to set the default schema for all 4 new users to new schema, but what i know that when we create a user the shema is gets created automatically. can we do this that there are 4 different users working on same schema without specifiying the name of schema in which they r creating objects.

  4. #4
    Join Date
    Jul 2003
    Posts
    2,296
    i think I mis-spoke.
    all your users would have to specify what owner they are creating
    objects as. There is no way around that.

    However, you would want to make sure everyone is creating the
    objects in the proper tablespaces so you should assign everyone
    the same default tablespace.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •