cancel
Showing results for 
Search instead for 
Did you mean: 

Possible to use BOUSER in sql e.g in data security profile outwith BEGIN_SQL + END_SQL?

former_member272336
Participant
0 Kudos

Hi,

Is it possible to use BOUSER to appear in the sql e.g

publisher_name = @variable('BOUSER')

Have used in BEGIN + END_SQL but not used in data security profiles before.

Thanks

View Entire Topic
Former Member
0 Kudos

It is possible to use BOUSER in the row restriction portion of a data security profile.

However, if you want to filter results for ALL the users by SQL based on their username, you might consider using BOUSER in a filter automatically applied to either a folder and its subfolders or to the entire universe.  This provides personalized row-based security without the overhead of a data security profile.

former_member272336
Participant
0 Kudos

Thanks for reponse.

Works fine  - tried it in data_security_profile and value of BOUSER (i.e. login name gets created in sql) as expected.