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.