Skip to Content
author's profile photo Philip O'Rourke
0
Philip O'Rourke

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

Posted on Dec 02, 2014 at 11:51 AM 23 Views

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 03, 2014 at 08:20 AM
    2

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Ajay Gupta
    Ajay Gupta
    Posted on Dec 02, 2014 at 06:58 PM
    1

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.