• 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
Sheriff
Posts: 35977
422
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.
 
Happiness is not a goal ... it's a by-product of a life well lived - Eleanor Roosevelt. Tiny ad:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!