Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED]DBA security question
Go
New
Search
Notify
Tools
Reply
  
[SOLVED]DBA security question
 Login/Join
 
Platinum Member
posted
Hi

I have following car_2.mas with DBA setting:

 
FILENAME=CAR_2, SUFFIX=FOC     ,
 REMARKS='Legacy Metadata Sample: car', $
  SEGMENT=ORIGIN, SEGTYPE=S1, $
    FIELDNAME=COUNTRY, ALIAS=COUNTRY, USAGE=A10, FIELDTYPE=I, $
  SEGMENT=COMP, SEGTYPE=S1, PARENT=ORIGIN, $
    FIELDNAME=CAR, ALIAS=CARS, USAGE=A16, $
  SEGMENT=CARREC, SEGTYPE=S1, PARENT=COMP, $
    FIELDNAME=MODEL, ALIAS=MODEL, USAGE=A24, $
  SEGMENT=BODY, SEGTYPE=S1, PARENT=CARREC, $
    FIELDNAME=BODYTYPE, ALIAS=TYPE, USAGE=A12, $
    FIELDNAME=SEATS, ALIAS=SEAT, USAGE=I3, $
    FIELDNAME=DEALER_COST, ALIAS=DCOST, USAGE=D7, $
    FIELDNAME=RETAIL_COST, ALIAS=RCOST, USAGE=D7, $
    FIELDNAME=SALES, ALIAS=UNITS, USAGE=I6, $
  SEGMENT=SPECS, SEGTYPE=U, PARENT=BODY, $
    FIELDNAME=LENGTH, ALIAS=LEN, USAGE=D5, $
    FIELDNAME=WIDTH, ALIAS=WIDTH, USAGE=D5, $
    FIELDNAME=HEIGHT, ALIAS=HEIGHT, USAGE=D5, $
    FIELDNAME=WEIGHT, ALIAS=WEIGHT, USAGE=D6, $
    FIELDNAME=WHEELBASE, ALIAS=BASE, USAGE=D6.1, $
    FIELDNAME=FUEL_CAP, ALIAS=FUEL, USAGE=D6.1, $
    FIELDNAME=BHP, ALIAS=POWER, USAGE=D6, $
    FIELDNAME=RPM, ALIAS=RPM, USAGE=I5, $
    FIELDNAME=MPG, ALIAS=MILES, USAGE=D6, $
    FIELDNAME=ACCEL, ALIAS=SECONDS, USAGE=D6, $
  SEGMENT=WARANT, SEGTYPE=S1, PARENT=COMP, $
    FIELDNAME=WARRANTY, ALIAS=WARR, USAGE=A40, $
  SEGMENT=EQUIP, SEGTYPE=S1, PARENT=COMP, $
    FIELDNAME=STANDARD, ALIAS=EQUIP, USAGE=A40, $
END
DBA=DBA1, $
USER=NOX01, ACCESS=R, RESTRICT=VALUE_WHERE, NAME=SYSTEM, VALUE=COUNTRY EQ 'JAPAN';, $
 


afterward, user NOX01 login into webFOCUS and try using IA to create a report by selecting car_2.mas and get '(FOC047) THE USER DOES NOT HAVE SUFFICIENT ACCESS RIGHTS TO THE FILE:
filename'

my objective is to set user 'NOX01' can only using this car_2.mas for reporting where Country EQ JAPAN in IA.

So here is question I don't really understand is the 'USER' attribute in DBA is mapping to which users management? in WebFOCUS Security Center? or EDASERVE?

and I read about this link:

https://webfocusinfocenter.inf...ource/metadata39.htm

don't really understand where I should 'SET' those attribute?

This message has been edited. Last edited by: nox,


WebFOCUS v8.2.06 , Windows
 
Posts: 124 | Registered: August 29, 2019Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Nox

I think you are missing the SET PASS=&FOCSECUSER command. It can be in the server profile (edasprof.prf) or in the _site_profile


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 2063 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Hi Chuck,

Thanks for the hint, after I read this topic, I got it work now.

http://forums.informationbuild...1057331/m/3817054686


WebFOCUS v8.2.06 , Windows
 
Posts: 124 | Registered: August 29, 2019Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED]DBA security question

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.