Create more than one user id to the same DB schema in Oracle 10g
posted 10 years ago
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.