| Navi |
Posted: Jun 15, 2007 08:12:57 AM |
Total Post: 60
Joined: Jun, 2007
|
Hi,
I have created two users Nandish and Rajesh.
I want to create Nandish's table in Rajesh schema so what are the privileges i need to give to two users and what are the steps to do so?
1)Please explain with an example?
2)What's the use of creating ones table in others schema?
Regards,
Naveen |
|
|
 DreamzZ |
| Posted: Jul 23, 2007 03:16:48 PM |  |
|
Total Post: 23
Joined: Jul, 2007
|
create any table SYStem privelge.
create table a.test
as
select * from user_users;
|
|
|
|
|
| Ramesh Joyisa |
| Posted: Aug 17, 2007 05:35:07 AM | |
|
Total Post: 246
Joined: Aug, 2007
|
Create Synonym for the other user
|
|
|
|
|
| parthokonar |
| Posted: Sep 26, 2007 11:24:01 AM | |
|
Total Post: 27
Joined: Sep, 2007
|
Nandish should be given create any table system priv
Grant create any table to nandish
create table rajesh.test ( col1 number);
table will be created on the rajesh's schema.
creating tables in another schema it all depends upon the application which it needs.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
