| edit tables of other users [message #154730] |
Tue, 10 January 2006 06:05  |
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  |
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 |
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 |
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 |
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 |
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 |
 |
Mahesh Rajendran
Messages: 10707
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
