I needed to set-up another data source using the same database server

—–

So using the SQL Plus, i created a user and granted privileges for it.

Creating User
SQL> create user username identified by password default tablespace user_tablespace temporary tablespace temp_tablespace;
e.g.
SQL> create user wpsdbusr identified by password default tablespace users temporary tablespace temp;


Granting Privileges
SQL> grant connect, resource to username;
e.g.
SQL> grant connect, resource to wpsdbusr;

now i have another data source for my project using the same database.

Posted on 08.13.08 to Oracle by Julz. Subscribe to follow comments on this post. No comments yet. Add your thoughts or trackback from your own site.

• BROWSE / IN TIMELINE
• « Transposing Records into One Field
• » Linux: finding files given text within…

• BROWSE / IN Oracle
• « Transposing Records into One Field