How To Create User

kash

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

NaviDev

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.

kash

Not at all angry. How do i set it up in SQL. Can u help me out

kash

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

Fordewind

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.

anand_sri12

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 ..................

hawwa

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.

kash

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_Piddington10199

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

sendoh

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

kash

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.

sendoh

ooops I'm sorry Kash..I forgot to use the codecoverage

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...

kriki

[Topic moved from Navision forum to SQL General forum]