"Describe Error" when using Proc SQL to read unprotected columns from a table with protected columns

LM2022 — Wed, 01 Mar 2023 15:39:14 GMT

Good morning,

I am sure this is a simple problem but I can't seem to find an answer online. I am trying to query an SQL database that contains some protected columns (like a confidential phone number). When I use Proc SQL specifying the variables I want, none of which are protected, I get a describe error. Code and error below:

55 proc sql;
56 create table xx1 as
57 select userID, fname, lname,
57 ! email1, mailaddr
58 from OPSDB.useraccount;
ERROR: Describe error: IColumnsInfo::GetColumnInfo failed. : Deferred prepare could not be
completed.: The SELECT permission was denied on the column 'PHONENUM' of the object
'USERACCOUNT', database 'USERDB', schema 'dbo'.
59 quit;

Any thoughts? Thanks in advance.

Re: "Describe Error" when using Proc SQL to read unprotected columns from a table with pro

SASKiwi — Wed, 01 Mar 2023 19:05:29 GMT

Try an SQL Passthrough query to see if you get the same problem:

proc sql;
connect using OPSDB;
create table xx1 as
select * from connection to OPSDB
(select userID, fname, lname, 
email1, mailaddr
from useraccount
);
quit;

topic "Describe Error" when using Proc SQL to read unprotected columns from a table with protected columns in SAS Procedures

"Describe Error" when using Proc SQL to read unprotected columns from a table with protected columns

Re: "Describe Error" when using Proc SQL to read unprotected columns from a table with pro