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

[former_member272336]

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

[Former Member · Accepted solution]

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 · Accepted solution]

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.

[CdnConnection]

Philip,

   You best option is to create a objects in the Universe and then try to use it with the Publication.  You can NOT 'BOUSER' outside of BOBJ Platform.

Regards,

Ajay