insufficient privileges when i create a tablespace in user flshop

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • alituri
    New Member
    • Feb 2013
    • 1

    insufficient privileges when i create a tablespace in user flshop

    how to grant all privileges to my created user "flshop".

    SQL> connect flshop/admin;
    Connected.
    SQL> create tablespace shoptb
    2 datafile
    3 'E:\oracle\prod uct\10.2.0\flas h_recovery_area \shoptb_01.dbf' SIZE 200M autoextend off,
    4 'E:\oracle\prod uct\10.2.0\flas h_recovery_area \shoptb_02.dbf' SIZE 200M autoextend off
    5 logging
    6 extent management local;
    create tablespace shoptb
    *
    ERROR at line 1:
    ORA-01031: insufficient privileges
  • PreethiGowri
    New Member
    • Oct 2012
    • 126

    #2
    try this command
    "Grant create session, grant any privilege to 'user_name'; "
    also refer this site for your reference

    Comment

    • rski
      Recognized Expert Contributor
      • Dec 2006
      • 700

      #3
      Code:
      GRANT CREATE TABLESPACE TO flshop;

      Comment

      • arumurali
        New Member
        • Mar 2013
        • 20

        #4
        GRANT your created workspace to user;

        Comment

        Working...