Chat now with support
Chat with Support

Toad Data Studio Subscription 1.0 - Installation Guide

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.

  

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating