Cannot drop table-Urgent [message #20645] |
Mon, 10 June 2002 20:03 |
manish mendiratta
Messages: 110 Registered: May 2002
|
Senior Member |
|
|
Hi,
I have a user named us01 who has connect,resource and DBA roles. Problem i am facing is that this user can create a table but cannot drop it. The error its giving is ORA-0604. However, if i connect thru system/manager i am able to drop the table. Pls help.
Thanks in advance
ManishM.
|
|
|
|
|
Re: Cannot drop table-Urgent [message #20671 is a reply to message #20645] |
Wed, 12 June 2002 18:32 |
Su
Messages: 154 Registered: April 2002
|
Senior Member |
|
|
Maaher, since it is urgent as he says, and to draw the attention whoever sees and answers the query at least in one forum (if some one who misses in another), the people normally (some times) would post in multiple forums. But your answer hurts the feelings of the one who posted it. Try to understand. And you did not mention, which forum is it. You just mentioned, 'See reply in other forum'. And dont always assume your answer to the query impressed or worked for the one who posted it. Please be advised, be professional and polite. Remember, this is a public forum.
Keep smiling.
Good luck :)
|
|
|