edit tables of other users [message #154730] |
Tue, 10 January 2006 06:05 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
gkrishn
Messages: 506 Registered: December 2005 Location: Putty a dark screen
|
Senior Member |
|
|
Hi
Is it possible to alter table owned by schemas from different schema.Pls tell me how
|
|
|
Re: edit tables of other users [message #154746 is a reply to message #154730] |
Tue, 10 January 2006 07:08 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
JSI2001
Messages: 1016 Registered: March 2005 Location: Scotland
|
Senior Member |
|
|
If you have permission to alter someone else's table then simply prefix the table name with the owner's name:
e.g
alter table HR.Table1 add (x int);
HTH
Jim
|
|
|
|
|
Re: edit tables of other users [message #154755 is a reply to message #154730] |
Tue, 10 January 2006 07:15 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
DanielRey
Messages: 11 Registered: January 2006 Location: Mendoza, Argentina
|
Junior Member |
|
|
Hi All.
There are two kinds of privileges over tables, they are for DML and for DDL.
DML are: DELETE, INSERT, UPDATE & SELECT.
DDL are: ALTER, INDEX & REFERENCE.
In this specific issue you need ALTER privilege over the object.
Regards
Daniel.
|
|
|
Re: edit tables of other users [message #154766 is a reply to message #154749] |
Tue, 10 January 2006 07:38 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
gkrishn
Messages: 506 Registered: December 2005 Location: Putty a dark screen
|
Senior Member |
|
|
gkrishn wrote on Tue, 10 January 2006 07:11 | What exact is that permission? is it update?
I think for SYS , can do anything on others tables, right?
|
Y ?
is it bad to excecute alter table HR.Table1 add (x int);
from SYS ?
|
|
|
|
Re: edit tables of other users [message #154772 is a reply to message #154730] |
Tue, 10 January 2006 07:52 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
DanielRey
Messages: 11 Registered: January 2006 Location: Mendoza, Argentina
|
Junior Member |
|
|
Quote: | Y ?
is it bad to excecute alter table HR.Table1 add (x int);
from SYS ?
|
Can you kill a spider using a gun? Yes, you can, but is not a good idea.
Can you have a shave using a sword? Yeah, you can, but is not a good idea.
And so on.
Regards.
Daniel
|
|
|
Re: edit tables of other users [message #154774 is a reply to message #154730] |
Tue, 10 January 2006 07:57 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
gkrishn
Messages: 506 Registered: December 2005 Location: Putty a dark screen
|
Senior Member |
|
|
will tell you scenatio.in our project all DBAs are login using sys.we dont have any other IDs.
So do you mean to say i have to reset password for tht particualr user, then do the task then again reset back to same as before.
Sorry i am fresh to Oracle.advice me
|
|
|
Re: edit tables of other users [message #154776 is a reply to message #154774] |
Tue, 10 January 2006 08:10 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](/forum/images/custom_avatars/42800.jpg) |
Mahesh Rajendran
Messages: 10708 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
>> our project all DBAs are login using sys
Nice~.
Get prepared for surprises. Sometime, someday, you will face the consequences.
All you have to do is,
create a 'DBA' user.
login as that DBA user, do your task.
Or
a create a user who can alter the HR tables.
or
Login as HR user.
Talk to your DBA.
|
|
|