Unanswered Active Topics Forums Search

UserName:
Subject:	Low Privilege User account for SQL 7
Body:	[quote]Posted By n/a on 10/09/2001 12:46 PM The DTS package are exporting SQL tables to an empty Access database. I.E. I've used the DTS wizard to export table A from Test DB on the SQL server to an empty Access MDB located on the same machine. By login entry to SQL server, do you mean SQL User account? I do have an SQL login User account called SQLTest that is assigned to the the sysadmin role. This is the same Windows User account that is assigned to the SQL Server service and SQL Agent service. I'd notice that the SQLTest account only has database access to the master, model, and tempdb databases. Do I need to grant the user account public and db_owner permission to the Test DB? Also the SQLTest account does have full control to the empty Access MDB. [/quote]
Show Replies:

ActiveForums 3.6