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