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

Accepted Solution Solved
Reply
Contributor
Posts: 21
Accepted Solution

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

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: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE| _DISARM| STOP| _DISARM| 2018-06-14T15:37:02,614+05:1800| _DISARM| WorkspaceServer| _DISARM| SAS| _DISARM|
| _DISARM| 90759168| _DISARM| 18968576| _DISARM| 10| _DISARM| 16| _DISARM| 131267| _DISARM| 1986228339| _DISARM| 0.078000|
_DISARM| 0.156000| _DISARM| 1844590022.459000| _DISARM| 1844590022.615000| _DISARM| 0.031200| _DISARM| | _ENDDISARM


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;

 


Accepted Solutions
Solution
‎06-14-2018 07:00 AM
Super User
Super User
Posts: 9,599

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

Posted in reply to kuppusamy

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.

 

View solution in original post


All Replies
Solution
‎06-14-2018 07:00 AM
Super User
Super User
Posts: 9,599

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

Posted in reply to kuppusamy

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.

 

Super User
Posts: 10,237

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

Posted in reply to kuppusamy

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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 85 views
  • 1 like
  • 3 in conversation