Use the Data Object editor to create roles.
Procedure
To create a database role:
- Expand a database connection object in the Data Source
Explorer (or
the Administration Explorer for products that include this view).
- Browse to the Roles folder.
- Right-click the Roles folder, and select Create. For products that include the Administration Explorer, select New
Role. The Data Object editor opens.
- Modify the privileges for the new role in the Data
Object Properties section of the editor.
- Expand the DDL section of the editor,
and click Preview DDL .
If you
make additional changes in the Data Object Properties or Impacted
Objects sections, click Preview DDL again
to refresh the generated script.
You cannot type directly in
the DDL section of the editor. If you want to modify the generated
DDL script, you can click Open with SQL editor to
open the script in the SQL editor, where you can make changes and
save the script to an
existing data project. You can also use this option to save your
changes to an SQL script that you can run later.
- After you are satisfied with the generated DDL script,
click Run DDL in the Data Object
Management section.
Results
The generated DDL script is run on the database, and the new
role is displayed in the explorer in the
Roles folder.
The Data Output view displays the results, including any errors that
occurred.