Loading ...
Sorry, an error occurred while loading the content.

Privilage problem

Expand Messages
  • Ashish
    i had a basic problem i want to create a new user and scema in that so i have taken following steps but came across error while creating scema with user step
    Message 1 of 2 , Aug 1, 2005
    • 0 Attachment
      i had a basic problem

      i want to create a new user and scema in that

      so i have taken following steps but came across error while creating
      scema with user

      step 1) To create table space for user

      =>conn sys/sys as sysdba;
      =>create tablespace ashish
      datafile 'D:\oracle\oradata\OMSAIRAM\ASHISH.DBF' size 2M,
      'D:\oracle\oradata\OMSAIRAM\SMITH.DBF' size 1M;

      Tablespace created.

      step 2) create user and assign tablespace for user

      create user ash identified by ash default tablespace ashish
      temporary tablespace temp;

      User created.

      step 3) grant privilage to user

      grant role grant connect to ash;

      Grant successed

      step 4)create scema object (table) in that user

      create table a
      (x number);

      create table a
      *
      ERROR at line 1:
      ORA-01950: no privileges on tablespace 'ASHISH'

      how can i avoid the above error
      although the default tablespace is ashish for user ash (step 2)
      why i encounted with error as "no privileges on tablespace 'ASHISH'"
      in step 4

      waiting for response

      reagrds
      ashish Attarde
    • Michael Gerholdt
      I m not sure what this line really does: grant role grant connect to ash; shouldn t it just be : grant connect to ash; connect being one of Oracle s built-in
      Message 2 of 2 , Aug 2, 2005
      • 0 Attachment
        I'm not sure what this line really does:

        grant role grant connect to ash;

        shouldn't it just be :

        grant connect to ash;

        'connect' being one of Oracle's built-in role that has 'create table'
        privilege among others.


        -----Original Message-----
        From: SQLQueriesNoCode@yahoogroups.com
        [mailto:SQLQueriesNoCode@yahoogroups.com] On Behalf Of Ashish
        Sent: Tuesday, August 02, 2005 2:29 AM
        To: SQLQueriesNoCode@yahoogroups.com
        Subject: [SQLQueriesNoCode] Privilage problem

        i had a basic problem

        i want to create a new user and scema in that

        so i have taken following steps but came across error while creating
        scema with user

        step 1) To create table space for user

        =>conn sys/sys as sysdba;
        =>create tablespace ashish
        datafile 'D:\oracle\oradata\OMSAIRAM\ASHISH.DBF' size 2M,
        'D:\oracle\oradata\OMSAIRAM\SMITH.DBF' size 1M;

        Tablespace created.

        step 2) create user and assign tablespace for user

        create user ash identified by ash default tablespace ashish
        temporary tablespace temp;

        User created.

        step 3) grant privilage to user

        grant role grant connect to ash;

        Grant successed

        step 4)create scema object (table) in that user

        create table a
        (x number);

        create table a
        *
        ERROR at line 1:
        ORA-01950: no privileges on tablespace 'ASHISH'

        how can i avoid the above error
        although the default tablespace is ashish for user ash (step 2)
        why i encounted with error as "no privileges on tablespace 'ASHISH'"
        in step 4

        waiting for response

        reagrds
        ashish Attarde
      Your message has been successfully submitted and would be delivered to recipients shortly.