How To Create User

kashkash Posts: 11Member
edited 2008-06-05 in SQL General
COULD YOU PLS HELP ME IN CREATING A USER. i AM USING SQL SERVER AND NAVISION 4.0
I HAVE CREATED USER THROUGH TOOLS- SECURITY- DATABASE LOGIN-
I HAVE CREATED USER AND ROLES. BUT I COULDNT FIND ANY OPTION TO SETUP THE PASSWORD.

I WOULD APPRECIATE IF ANYONE COULD HELP ME OUT IN THIS.

THANKS IN ANTICIPATION

KASH

Comments

  • NaviDevNaviDev Posts: 364Member
    Typing in all caps means your "angry"?

    If you are using SQL Option for navision. Setting up of database login user is in the SQL security.
    Navision noob....
  • kashkash Posts: 11Member
    Not at all angry. How do i set it up in SQL. Can u help me out
  • kashkash Posts: 11Member
    I have created a user inSQL server
    and also created a user in Navision using Tools-Security option.
    But i am not able to login to Navision? Can anybody help?
    (I am using Database authenticatin)
    Thanks
    Prakash
  • FordewindFordewind Posts: 27Member
    kash wrote:
    I have created a user inSQL server
    and also created a user in Navision using Tools-Security option.
    But i am not able to login to Navision? Can anybody help?
    (I am using Database authenticatin)
    Thanks
    Prakash

    When you are creating a new user in SQL, you must choose an SQL Server Authentication and insert password.
    Nav 4.0 sp3
  • anand_sri12anand_sri12 Posts: 71Member
    You may first set up a user in SQL

    For example I have created a user through SQL Server enterprise edition
    Goto your server > Security > Logins > New login
    Here specify the database of navision and create user then set the password
    now u must create user in navision sql server option with the same name
    as it is in sql server. You dont need to set password here in navision
    thats it ..................
    With thanks

    Anand Kumar
    Navision Technical Consultant
  • hawwahawwa Posts: 106Member
    After created the database users in SQL Server, you need to grant the the user access permission in SQL Server and then do security syncronization in Navision.
    To grant permission in SQL Server,
    1) In the Enterprise Manager, expend your server and the expand the Security Folder. Click on Logins under the Security folder.
    2) Right Click on the user that you want to grant access and then select Properties.
    3) Select the Data Acccss tab.
    4) In the Permit Column, put a check mark on your Navision database.
    5) In the Permit in Database Role, place a check mark on public.
    6) Click on the OK button to accept the setting.

    To syncronize the security with navision,
    1) Open Navision with a user who has admin right.
    2) Go to Tools --> Security --> Syncronize All Logins to syncronize the security. This will syncronize all security setting in Navision to sql server. You can also choose to syncronize user by user instead syncronize all users at one go.

    After syncronization, you should be able to login to your Navision.
  • kashkash Posts: 11Member
    Thanks a lot for the reply.

    How do i setup user roles. I tried to setup the roles/permissions. But it seems you should know the tables/link tables etc. Is there any way we can find linking and required objects. For. e,.g i want to give access rights to a user who will make GL journal entry, GL Ledger setup.


    Thanks in anticaption
    Kash
  • Ian_Piddington10199Ian_Piddington10199 Posts: 170Member
    There are a lot of 'out of the box' roles that should be in the system. Actually going through and setting up a new role requires a lot of knowledge of the App and a fair amount of trail and error unfortunatly.

    You can try setting it up yourself but, as someone that has been through it, I would advise you talk to someone that has done it before as it will make the process less painful.

    If your an end user site have a chat with your reseller. If your at a reseller have a chat with a more experienced consultant that knows the Roles area.


    Regards

    Ian
    Regards

    Ian
  • sendohsendoh Posts: 207Member
    hi Kash,

    actually assigning a user role is a lot of work for us..but I made some steps to less it..

    1. go to file->Database->Information->Tables
    hit ctrl-A to copy all then paste it in notepad then Save it as beforepost.txt

    2. then make the all scenario that your user do in Nav..create,posting,etc.
    example: the Purchaser
    create Blanket order,quotes,P.O,etc.
    -after you do all the scenario then

    go to file->Database->Information->Tables
    hit ctrl-A to copy all then paste it in notepad then Save it as
    afterposting.txt

    3. open your UltraEdit then compare the Beforeposting.txt and afterposting.txt

    all changes in afterposting.txt vs Beforeposting.txt means the table that you will add to the permission in your purchaser Role. ofcourse we have to look what form,report,codeunit etc that call or use that table... #-o
    Sendoh
    be smart before being a clever.
  • kashkash Posts: 11Member
    Thanks a lo Sendoh. Seems not a bad idea. Only thing is you should have some patience to do that. And this will tell you which all the tables is getting affected by way of inserting records. But also i feel this will not give any idea of those tables which used for display purpose. E.g purchase order entry - vendor master or payterms table.
  • sendohsendoh Posts: 207Member
    ooops I'm sorry Kash..I forgot to use the codecoverage :mrgreen:

    go to Tools-> Debugger-> Code Coverage ->start.. then do the scenario of the role You want to assign(create,post etc.) afterward back to code coverage. now you will see all the object affected...
    :lol:
    Sendoh
    be smart before being a clever.
  • krikikriki Posts: 7,915Member, Moderator
    [Topic moved from Navision forum to SQL General forum]
    Regards,Alain Krikilion
    Use the SEARCH,Luke! || No PM,please use the forum. || May the <SOLVED>-attribute be in your title! || Read Forum Rules before making a posting

Sign In or Register to comment.