ERROR: User does not have appropriate authorization level for file temp.xxxxxx

kuppusamy — Thu, 14 Jun 2018 10:30:38 GMT

MPRINT(FCF_RISK_CLASS_LIST_EXTRACT): proc sql noprint;
MPRINT(FCF_RISK_CLASS_LIST_EXTRACT): create table fcf_rpt.risk_classifier_report_data as select cc.risk_classifier_category_name
, cc.risk_classifier_category_desc , rc.risk_classifier_name , rc.risk_classifier_short_desc , rc.risk_classifier_desc ,
rc.risk_classifier_type_code , put(rc.risk_classifier_type_code,$classifier_type.) as type_desc format=$50. , rc.active_ind ,
rc.weight , rc.source_table , rc.source_column , rc.source_value , rc.classifier_fact_column, rc.operator_desc ,
rc.classifier_threshold , datepart(rc.create_date) as created FORMAT WORDDATE20., rc.create_user_id , rc.version_number from
seg_kc.fsk_risk_classifier_category as cc , seg_kc.fsk_risk_classifier as rc where cc.risk_classifier_category_id =
rc.risk_classifier_category_id and cc.logical_delete_ind = 'N' and rc.logical_delete_ind = 'N' order by
cc.risk_classifier_category_name , cc.risk_classifier_category_desc ;
NOTE: Optimization for the PUT function was skipped because the referenced format, $CLASSIFIER_TYPE, does not have an OTHER= range
defined.

ERROR: User does not have appropriate authorization level for file FCF_RPT.RISK_CLASSIFIER_REPORT_DATA.DATA.

NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
MPRINT(FCF_RISK_CLASS_LIST_EXTRACT): quit;

NOTE: PROCEDURE SQL used (Total process time):
real time 0.15 seconds
47 The SAS System 15:36 Thursday, June 14, 2018

cpu time 0.07 seconds

MPRINT(FCF_RISK_CLASS_LIST_EXTRACT): ;
VERSION 6.3M1
ERROR: Unable create fcf_rpt.risk_classifier_report_data.
MPRINT(FCF_RISK_CLASS_LIST_EXTRACT): ;
MPRINT(FCF_RISK_CLASS_LIST_EXTRACT): ;
4171 %fcf_system_admin_extract;

Re: ERROR: User does not have appropriate authorization level for file temp.xxxxxx

RW9 — Thu, 14 Jun 2018 10:40:39 GMT

Its a good idea to describe your problem. Hence the answer I will give is the only thing I can get from what you posted:

ERROR: User does not have appropriate authorization level for file FCF_RPT.RISK_CLASSIFIER_REPORT_DATA.DATA.

Solution: Give user the appropriate permission to that file/folder/database.

Re: ERROR: User does not have appropriate authorization level for file temp.xxxxxx

Kurt_Bremser — Thu, 14 Jun 2018 10:51:23 GMT

Either dataset FCF_RPT.RISK_CLASSIFIER_REPORT_DATA already exists and the user in question does not have write permissions on it, and/or the user in question does not have write permission on the directory that library FCF_RPT points to.

If FCF_RPT is a library accessed with the META engine, SAS metadata permissions must also be checked.

topic ERROR: User does not have appropriate authorization level for file temp.xxxxxx in SAS Programming

ERROR: User does not have appropriate authorization level for file temp.xxxxxx

Re: ERROR: User does not have appropriate authorization level for file temp.xxxxxx

Re: ERROR: User does not have appropriate authorization level for file temp.xxxxxx