Selecting Browse Mode in Meta Data Browser
When you run Meta Data Browser as a stand-alone snap-in, you can set a browse mode at the repository database level to determine the scope of actions that are available to you. Browse modes include End User, Power User, and Administrator. You can choose different browse modes for each database.
The scope of actions for each browse mode includes the following:
- Creating, editing, and deleting registration information can be performed in all browse modes.
- Viewing the Contents folder and setting display options can be performed in all browse modes.
- Creating, editing, and deleting objects and object properties can be performed in Power User and Administrator browse mode.
- Viewing the Information Models folder can be performed in Administrator browse mode. In addition, only Administrators can view repository identifiers.
Browse modes apply exclusively to repository databases and have no impact on Microsoft® SQL Server™ 2000 user modes, Microsoft Windows NT® 4.0 user modes, or Microsoft Windows® 2000 user modes. In other words, being a repository Administrator does not confer administrator rights in SQL Server.
You cannot change the browse mode if you are running Meta Data Browser from within SQL Server Enterprise Manager. From within SQL Server Enterprise Manager, Meta Data Browser can only be run in End User mode.
To set a browse mode, you must select it during database registration. The browse mode you select is part of the registration information. To select a different browse mode, you must edit registration properties. For more information about the scope of actions each user mode supports, see Database Registration Properties Dialog Box.
See Also
Editing Registration Properties in Meta Data Browser
Registering a Repository Database in Meta Data Browser