Privileges Required to use Locks 
To use locks, you need either:
scheduler-administrator role
system, partition or isolation goup-level permissions
object-specific prvileges
u need one of the following privilege ranks to be able to create locks:
Create - allows you to create locks on the level the privilege was granted (system, partition, isolation-group), you have no further privileges through this rank, you automatically get privileges on locks you create.
Edit - allows you to create, view, and edit all locks on the level the privilege was granted (system, partition, isolation-group)
Delete - allows you to create, view, and delete all locks on the level the privilege was granted (system, partition, isolation-group)
All - full control over all locks on the level the privilege was granted (system, partition, isolation-group)
To successfully edit a lock, you have to have one the following privileges:
Edit - privilege rank on the lock, or on locks in its partition, isolation group or system-wide
Delete - privilege rank on the lock, or on locks in its partition, isolation group or system-wide
All - privilege rank on the lock, or on locks in its partition, isolation group or system-wide
Locks can reference the following objects, you need at least View privileges on these objects when you want to edit a lock that references them:
Application