-
truncate privs
Hi
Is it possible to assign truncate privs to another user?
I tried the following and it doesnt work.
grant truncate on table A to user A;
-
Hi
grant the drop table privelege to user A .Then it will work.
regards
Hrishy
-
Nope, u can't.
SQL> create table dummy_fac as select * from m_fac;
Table created.
SQL> grant truncate on dummy_fac to adm2;
grant truncate on dummy_fac to adm2
*
ERROR at line 1:
ORA-00990: missing or invalid privilege
PNRDBA
-
Hi
I do not want to drop and re-create the table. I just want to clear the table. As there are mnay records inside therefore I would like to use truncate instead of delete.
In the first place, is there a grant truncate in Oracle??
Thanks!
-
There is no TRUNCATE privilege, in order to do this you will need to grant the DROP ANY TABLE privilege to the user if they don't own the object.
Regards
Jim
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
-
Originally posted by mooks
In the first place, is there a grant truncate in Oracle??
No, there is not. The only system-provided method is the one suggested by hrishy (GRANT DROP ANY TABLE TO ...). For a more safe alternative, check
http://www.dbasupport.com/forums/sho...threadid=20154
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
In a procedure, cannot just use the command truncate table right? There will be an error.
create procedure abc as
begin
truncate table a;
end;
/
Last edited by mooks; 10-23-2002 at 05:30 AM.
-
Nope, you'll have to use dynamic SQL.
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
execute immediate '************';
-nagarjuna
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|