Welcome to the CodeSmith Community!

How-to: Create a new Oracle User

CodeSmith Community

A description has not yet been added to this group.

How-to: Create a new Oracle User

Rate This
  • Comments 2

Every now and then I need to create a new Oracle user to test the CodeSmith Generator OracleSchemaProvider. I wanted to outline the steps that I use to create a new user as well as change the password of an existing user.

The first step one needs to take is to create a new user but you may not remember your login information if it has been a while. At this point I always open up SQL Plus from the start menu and enter in the following user name when prompted.

/ as sysdba


This allows you to connect as the sysdba user without remembering any credentials. Please note that the passwords and/or steps below may not be the best practice for password security but all of my machines are behind a firewall and are on virtual machines for testing with no access to the world wide web. At this step you can change any of the user's passwords in oracle like the sys account.  Here is the command to reset the SYS users password.

alter user sys identified by ;

Now you are ready to create a new user by entering in the following statement.

create user  identified by ;


Next we will unlock the user and grant connection access so they can login.

alter user  account unlock;
grant connect to ;


Finally, I grant some more rights to the user so we can import backups and not have to worry about permissions. Please note that I wouldn't recommend doing this on a production database. Please see this documentation for setting the proper permissions.

grant resource to ;
alter user  quota unlimited on users;

kick it on DotNetKicks.com

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment
  • * Please enter your name
  • * Please enter a comment
  • Post
  • You've been kicked (a good thing) - Trackback from DotNetKicks.com

  • Thank you for submitting this cool story - Trackback from DotNetShoutout

Page 1 of 1 (2 items)