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|
What permissions do users need for Wise Package Studio (WPS) databases?
WPS any version
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.
Article URL http://www.symantec.com/docs/HOWTO3241