Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Create more than one user id to the same DB schema in Oracle 10g

 
S. Palanigounder
Ranch Hand
Posts: 145
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I know it is a DBA question:

I have a DB schema, called abc, in Oracle 10g. When a user login
as abc, he/she can update/delete/query the data. I'm asked to create
another user id (e.g., xyz) who can do the same thing on the same schema.

Could anyone show me how to do it? I know I need login as SYS first.
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 35279
384
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You need to login as a DBA (like sys) and grant permissions for the second user. There are permissions for select, create, etc. See this article for the syntax.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic