Re: [HACKERS] 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