
Hi,

I need set lock table privilage for user, but now I must grant upload
priv. for it. But I needn't upload priv. for user. Upload is possible
via RULEs without GRANTed (upload) privilage for user.

My suggestion is add to GRANT command LOCK privilage.

 ....
  privilege is {ALL | SELECT | INSERT | UPDATE | DELETE | RULE | LOCK
 ....  							         ^^^^ 

							Zakkr
							


Thu, 22 Jul 1999 13:32:02 +0200 (CEST)
Zakkr <zakkr@zf.jcu.cz>
GRANT suggestion
Zakkr wrote:
> 
> Hi,
> 
> I need set lock table privilage for user, but now I must grant upload
> priv. for it. But I needn't upload priv. for user. Upload is possible
> via RULEs without GRANTed (upload) privilage for user.
> 
> My suggestion is add to GRANT command LOCK privilage.
> 
>  ....
>   privilege is {ALL | SELECT | INSERT | UPDATE | DELETE | RULE | LOCK

Oracle:

The table or view must be in your own schema or you must have 
LOCK ANY TABLE system privilege or 
you must have any object privilege on the table or view. 
              ^^^^^^^^^^^^^^^^^^^^

So, I agreed with new LOCK privilege with addition above.

Vadim

Thu, 22 Jul 1999 20:12:52 +0800
Vadim Mikheev <vadim@krs.ru>
Re: [HACKERS] GRANT suggestion