mibuso.com

Microsoft Business Solutions online community
It is currently Fri Oct 31, 2014 1:00 pm

All times are UTC + 1 hour




Post new topic Reply to topic  [ 13 posts ] 
Author Message
 Post subject: How To Create User
PostPosted: Tue Dec 11, 2007 10:03 am 
Offline

Joined: Tue Dec 04, 2007 12:17 pm
Posts: 9
Location: VA
Country: United States (us)
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


Top
 Profile  
 
 Post subject:
PostPosted: Tue Dec 11, 2007 10:40 am 
Offline

Joined: Mon Oct 01, 2007 7:53 am
Posts: 302
Location: Inside
Country: United States (us)
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....


Top
 Profile  
 
 Post subject: Create user
PostPosted: Tue Dec 11, 2007 11:04 am 
Offline

Joined: Tue Dec 04, 2007 12:17 pm
Posts: 9
Location: VA
Country: United States (us)
Not at all angry. How do i set it up in SQL. Can u help me out


Top
 Profile  
 
 Post subject: created User in SQL
PostPosted: Tue Dec 11, 2007 11:23 am 
Offline

Joined: Tue Dec 04, 2007 12:17 pm
Posts: 9
Location: VA
Country: United States (us)
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


Top
 Profile  
 
 Post subject: Re: created User in SQL
PostPosted: Tue Dec 11, 2007 11:51 am 
Offline

Joined: Tue Mar 01, 2005 2:40 pm
Posts: 27
Location: Moscow
Country: Russia (ru)
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


Top
 Profile  
 
 Post subject:
PostPosted: Tue Dec 11, 2007 1:45 pm 
Offline

Joined: Tue Feb 20, 2007 2:12 pm
Posts: 52
Location: Bangalore
Country: India (in)
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


Top
 Profile E-mail  
 
 Post subject:
PostPosted: Tue Dec 11, 2007 4:32 pm 
Offline

Joined: Fri Nov 12, 2004 2:24 am
Posts: 95
Location: Malaysia
Country: Malaysia (my)
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.

_________________
www.navision-girl.com


Top
 Profile E-mail WWW  
 
 Post subject: Roles-Permissions
PostPosted: Wed Dec 12, 2007 2:50 pm 
Offline

Joined: Tue Dec 04, 2007 12:17 pm
Posts: 9
Location: VA
Country: United States (us)
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


Top
 Profile  
 
 Post subject:
PostPosted: Wed Dec 12, 2007 11:23 pm 
Offline

Joined: Mon Oct 16, 2006 8:25 pm
Posts: 162
Location: Auckland
Country: New Zealand (nz)
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


Top
 Profile  
 
 Post subject:
PostPosted: Thu Dec 13, 2007 2:54 am 
Offline

Joined: Sat Dec 23, 2006 1:32 am
Posts: 205
Location: Malacanang
Country: Philippines (ph)
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.


Top
 Profile  
 
 Post subject:
PostPosted: Thu Dec 13, 2007 6:34 am 
Offline

Joined: Tue Dec 04, 2007 12:17 pm
Posts: 9
Location: VA
Country: United States (us)
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.


Top
 Profile  
 
 Post subject:
PostPosted: Thu Dec 13, 2007 8:42 am 
Offline

Joined: Sat Dec 23, 2006 1:32 am
Posts: 205
Location: Malacanang
Country: Philippines (ph)
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.


Top
 Profile  
 
 Post subject:
PostPosted: Thu Jun 05, 2008 7:56 pm 
Online
Moderator
MVP Microsoft Dynamics NAV
NAV TechDays 2014 attendee

Joined: Wed Jul 02, 2003 9:13 am
Posts: 7705
Location: Milan
Country: Italy (it)
[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

»»» Mark your calendar: NAV TechDays 2014 - 20 & 21 November 2014 ««« Visit the conference website: http://www.navtechdays.com


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 13 posts ] 

All times are UTC + 1 hour


Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: