Multiple schemas, single user, system privileges 
Author Message
 Multiple schemas, single user, system privileges

Hi,

  I have an oracle instance and have created two schemas db01 & db02.
I have a user user01.  I want this user user01 to have permissions to
create tables, views, indices, procedures, sequences etc on both the
schemas.

  My intention is to check up how transactions work with respect to
multiple schemas.  I would like to know whether two tables from
different schemas can participate in the same transaction.

  Basically I am trying to understand Oracle features by comparing it
to MSSQL, since I have more exposure to MSSQL than to Oracle.

  Thanks in advance

regards

zrb



Mon, 21 Feb 2005 15:28:35 GMT
 Multiple schemas, single user, system privileges


Quote:
>Hi,

>  I have an oracle instance and have created two schemas db01 & db02.
>I have a user user01.  I want this user user01 to have permissions to
>create tables, views, indices, procedures, sequences etc on both the
>schemas.

>  My intention is to check up how transactions work with respect to
>multiple schemas.  I would like to know whether two tables from
>different schemas can participate in the same transaction.

>  Basically I am trying to understand Oracle features by comparing it
>to MSSQL, since I have more exposure to MSSQL than to Oracle.

>  Thanks in advance

>regards

>zrb

So you need to read the Oracle manuals.
Apparently (given your multitude of questions over the last few days)
you seem to refuse to do so.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address



Mon, 21 Feb 2005 16:44:57 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. multiple schemas per user - possible?

2. When Single User Mode is not Single User Mode

3. How Do I use Become User System Privileges

4. Q: The "BECOME USER" system privilege

5. Multiple Schemas vs. Multiple Instances

6. Multiple schemas versus multiple databases

7. Multiple vs Single SQL Server User Id

8. Having multiple users manage a single job (WITHOUT SA)

9. Associate multiple user accounts to a single Login ID

10. SQL User Accounts - Single or Multiple Accounts?

11. Multiple users using single Access database

12. Multiple User(Single) on a MS-SQL Srv


 
Powered by phpBB® Forum Software