This discussion is archived
2 Replies Latest reply: Nov 29, 2012 4:17 AM by 976976 RSS

regarding user creation

ksbabu Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points