What permissions do users need for WPS databases?

Article:HOWTO3241  |  Created: 2005-09-15  |  Updated: 2008-10-30  |  Article URL http://www.symantec.com/docs/HOWTO3241
Article Type
How To

Product(s)


Problem
What permissions do users need for Wise Package Studio (WPS) databases?

Environment
WPS any version

 

Cause

Resolution
If you are using SQL Authentication for Wise Package Studio, create a SQL account that all your users can use.

While DBO permission on all stored procedures for the Workbench, Software Manager, and Wise Services Databases are preferred;  at a minimum, your users will need Read/Write permissions and Execute all stored procedures on those respective databases.

When installing Wise Package Studio on the server using a SQL database, the user performing the installation must be a DBA.


Legacy ID



2189


Article URL http://www.symantec.com/docs/HOWTO3241


Terms of use for this information are found in Legal Notices