2 Replies Latest reply: Nov 29, 2012 6:17 AM by 976976 RSS

    regarding user creation

    ksbabu
      Hi,
      i am login into sql developer with credentials SCOTT/TIGER
      in that user i want create new user,in such a case i am creating a user
      it raises an exception " IN SUFFICIENT PREVILAGES" PLSE
      solve this problem


      thanks
      sateesh
        • 1. Re: regarding user creation
          Prabodh
          Sateesh,
          i am login into sql developer with credentials SCOTT/TIGER
          <b>in that user i want create new user</b>,in such a case i am creating a user
          it raises an exception " IN SUFFICIENT PREVILAGES" PLSE
          solve this problem>
          Not sure what you means by the above highlighted statement.
          This is the Oracle Forms Forum. Your query belongs to Database General Forum and that where you need to post it.
          SCOTT/TIGER needs to be granted the CREATE USER System Privilege.

          Cheers,
          • 2. Re: regarding user creation
            976976
            Hi buddy ,

            Simple log in with system admin rights , which one have read and write privileges rights ,

            then execute your code , you can able create user ,

            Or if you have toad you can create by using tool wizards

            Thanks Shagul