Re: GRANT/PRIVILEGE PROBLEM: URGENT

To allow another user to TRUNCATE a table, that user must have the system privilege "DELETE ANY TABLE".

Regarding your note, I've been experiencing a similar problem in that a user/role will seem to suddenly lose the select permission on one or more views or execute permission on a procedure or function. I don't know what is causing this, but I set RESOURCE_LIMIT = FALSE in the initsid.ora file and it seems not to occur. (at least not in the past two days). I'm going to set it back to true after a few more days and see what happens. Could this be similar to what you are experiencing?

Alton

The man from the great white north wrote:

> DATABASE: 7.3.4.3 Sparc Solaris 2.5.1
>
> User TST_ENT wants to let user ADMIN truncate one of its table....
>
> PLEASE NOTE: A couple of weeks ago, one of my databases started
> showing all kinds of problems related to grants (execute) on
> procedures and packages. Even if I granted execute to procedures, I...
>
Received on Tue May 11 1999 - 15:26:01 CDT