|Date: ||Mon, 17 Nov 2008 22:48:48 +0100|
|Reply-To: ||"Jesper K. Hansen" <jkh-lists@MSECON.EU>|
|Sender: ||"SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>|
|From: ||"Jesper K. Hansen" <jkh-lists@MSECON.EU>|
|Subject: ||Re: Which user permissions are needed to fetch a view from MS-SQL
Server 2005 database?|
|Content-Type: ||text/plain; charset=UTF-8|
I will get back to you on that. I don't have access to the platform right now.
On Mon, Nov 17, 2008 at 22:18, Mary <email@example.com> wrote:
> What sort of error message do you get if you run code like this?
> libname mysql ....;
> data work.view1;
> set mysql.VIEW1;
> ----- Original Message ----- From: Jesper K. Hansen
> To: SAS-L@LISTSERV.UGA.EDU
> Sent: Monday, November 17, 2008 2:31 PM
> Subject: Which user permissions are needed to fetch a view from MS-SQL
> Server 2005 database?
> Dear Listers,
> I hope that someone, proficiently experienced with both SAS and MS-SQL
> Server 2005, will be able to help me with the question listed below.
> First off, a little detail concerning my setup:
> o Data storage/collection: MS-SQL Server 2005 running on Win2003 server
> Servername: myserver
> MS-SQL server login: mydomain\sas-prod with server role: public
> Database: MyDatabase
> Database user: mydomain\sas-prod with database-role: db_datareader
> o SAS products used: DI Studio on SAS DI Server
> Tables are imported to SAS datasets via ODBC and DI is handled on
> the SAS platform
> All tables from MyDatabase are imported to the SAS platform without
> problems. However, I cannot import views (queries) created on the SQL
> server; but I can browse the views.
> No doubt, this is a problem with database permissions on MS-SQL
> Server. What puzzles me is that I can access the database views from a
> number of other platforms (e.g. Excel, Access, StatTransfer, Stata -
> using ODBC) using a database user with the same permissions
> Does anyone know, which additional permissions I have to grant the
> database user, in order for him to import database views to the sas
> platform? I don't want to give the database user db_datawriter or
> db_ddladmin permission, if it is not nesescary.
> Thanks in advance.
> Jesper K. Hansen