I am trying to find out what rights to give a user so that they can access an SQL database and perform conflicts and conflict resolution, but not import into the database. We are using SQL Enterprise Manager v8.0. We are not using AMS. Thanks
Allen,I removed INSERT and UPDATE rights to the tables with prefixes of csmsi, csmsm, and csosc.The user will is still be able to invoke the Import operation, operation goes through and shows as being sucessfull. The package shows up in the group, bu...
Allen,I have gone into the database user properties and on the Objects:cstblConflictACEcstablConflictConfigurationcstblConflictPackagescstblConflictResultscstblConflcitResultsDestPkgscstblConflictTransformListI have checked SELECT, INSERT, UPDATE, DE...
Allen,The Manage Users Dialog box is a function of the Snap in AMS 2.0We are not using AMS. I would like to know what the specific permssion are for the objects Db_ datareader and DB_Datawriter. Unless you set specific permission on these objects the...
Allen,Thanks for responding but you are really not answering my question.We are using Admin Studio Professional and NOT AMS. I need to know what specific permissions to assign the user on the objects within SQL. Example the object of db_datawriter un...
