Skip to Content

Can add read-Only DB User but cannot see in authorization


I am successfully able to add the read-Only DB User to sap b1.. But I cannot see the user in Authorization and cannot login from that user..

I followed the admin guide for the instruction.

I am using SAP B1 8.82 PL08


Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Sep 24, 2013 at 09:37 AM


    The correct process is

    1.Set a read-only DB user on SQL Server and set following permission for SBO-COMMON and Company databases: public, db_datareader, db_denydatawriter
    2. Enter read-only DB user credentials into SAP Business One, Administration -> General -> Security -> Read Only DB User
    3. Create an SAP Business One User with full authorizations, but set Execute Non-select SQL Statement to 'No Authorization' (System Initialization -> Authorizations -> General Authorizations / Reports -> Query Generator -> Execute Non-select SQL Statement)

    4. Now this new Business One user can only use select SQL queries - in example from query manager.

    But please try above on 8.82 PL11 or above version

    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.