Lock and Unlock Objects
You can lock an object to prevent the object from being dropped by other users or to prevent certain attributes from being modified by other users.
Note: This feature is available in the Toad Data Studio Professional edition only and requires access to a Toad Intelligence Central server.
Who has Locking Privileges
The owner of an object, the administrator (root user), and any user with Manage privileges can lock an object.
To lock/unlock an object
-
Select the object and click one of the following icons in the Object Explorer toolbar or the right-click menu.
Locks the selected object. Unlocks the selected object.
Which Object Operations Are Locked
Once an object is locked, it cannot be modified or dropped, except by the user who locked it or by the administrator (root user). Only the user who locked it and the administrator (root user) can unlock it.
Locking an object prevents users (except the user who locked it and the administrator) from performing the following actions:
- Dropping an object
- Modifying an object's sharing options
- Modifying a snapshot's refresh schedule
- Manually refreshing a snapshot
- Overwriting the object when publishing
Which Object Activities Are Not Locked
- If a locked snapshot has a refresh schedule, it will continue to refresh at the scheduled time.
- Locked tables and views continue to reflect current data from the source. When you access a locked view, the query executes and retrieves the current data.