CLI describe Error

[Smitha9]

Hi,

I have a error when I run the code:

ERROR: CLI describe error: [Microsoft][ODBC SQL Server Driver][SQL Server]The SELECT permission was
denied on the column 'demo' of the object 'personname', database 'Warehouse', schema 'dbo'.

the code example:

libname SIT odbc noprompt =
"server=prd; DRIVER=SQL Server; Trusted Connection=yes"
DATABASE = Warehouse schema = dbo;
PROC SQL;
CREATE TABLE SITdat AS
SELECT DISTINCT
DurableKey AS personname
, testID
, testdate AS run_fate
FROM SIT.personname;

QUIT;

[yabwon]

Maybe this will help:

https://support.microsoft.com/en-us/topic/-2147217911-microsoft-odbc-sql-server-driver-sql-server-se...

Bart

[SASKiwi]

You need to talk to your SQL Server database administrator to be granted full select (read) permission on this table, although normally you would be granted read permission at the database or schema level. It looks like this table contains at least one column you don't have permission to read.