Learn more about Toad for SQL Server
at Quest.com

Find solutions and downloads at the
Toad for SQL Server Support Portal

< To bookmark a page, right-click the Page Title and select Add to Favorites / Bookmark This Page

Toad for SQL Server 5.7

You are here: Manage Administration Tasks > Set Up Toad Security > Define Server Side Objects

Define Server Side Objects

Toad stores security settings in the questsoftware.toadsecurity table. This table is created when you launch Toad Security from the Tools menu in a default location on the database server . If you do not want the table installed to the default location, you must edit the script to specify the tablespace used, location, etc.

Note: You must have privileges to create the questsoftware.toadsecurity table if it does not exist. If the table does exist, you must have privileges to insert, update, and delete the table to set security restrictions.

To define server side objects

Set up security.
In the Define Server Side Objects window, select the Toad Security Table tab.
Select the checkbox beside any users or roles you want to grant privileges to in the security table.
Click Show Script.
Edit the script to change the default location, tablespace used, and so on.