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.
... View more