topic CLI describe Error in New SAS User

CLI describe Error

Smitha9 — Tue, 04 Jan 2022 20:41:43 GMT

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;

Re: CLI describe Error

yabwon — Tue, 04 Jan 2022 20:45:11 GMT

Maybe this will help:

https://support.microsoft.com/en-us/topic/-2147217911-microsoft-odbc-sql-server-driver-sql-server-select-permission-denied-on-object-table-name-database-database-name-owner-dbo-9e197823-2a19-8135-1b9c-e89a2d6423e7

Bart

Re: CLI describe Error

SASKiwi — Tue, 04 Jan 2022 21:39:12 GMT

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.