Prev: NAVISION FOR ACCESS DETAILS
Next: Workflow Management Addon
From: sconant on 19 Nov 2009 16:20
Make sure your user has dbcreator or sysadmin role on your SQL server.

"Wing" wrote:

> Hi Savatage,
>
> I have set up a User Role with permissions. And some users assigned to this
> Role.
> The problem is two of them have right to create New Database; so i guess the
> problem is in SQL permission setup?
>
> thanks,
> wing
>
> "Savatage" wrote:
>
> > Have you set up any user roles and permissions in NAv?
> >
> > "Wing" wrote:
> >
> > > Dear ALL,
> > >
> > > Dynamic NAV 5.0 SP1, SQL 2005.
> > >
> > > I have created a Windows Authentication user (Member of Domain User);
> > > On SQL Server, Assign this Windows Authentication user to "Public" Server
> > > Role.
> > > And then Add this Windows Authentication user to Nav.
> > >
> > > The question is After this Windows Authentication user login to NAV, this
> > > user can click "Database => New" to create New Database on SQL Server, How
> > > come??
> > >
> > > Which setup is missing??
> > >
> > > Thanks.
> > > Wing
> > >
> > >
> > >
From: IrishPaul on 27 Nov 2009 17:00
Actually - I think Wing is trying to ensure those users CAN NOT use the
'File, Database, New' - think he wants that option to be greyed out for the
users.

"sconant" wrote:

> Make sure your user has dbcreator or sysadmin role on your SQL server.
>
> "Wing" wrote:
>
> > Hi Savatage,
> >
> > I have set up a User Role with permissions. And some users assigned to this
> > Role.
> > The problem is two of them have right to create New Database; so i guess the
> > problem is in SQL permission setup?
> >
> > thanks,
> > wing
> >
> > "Savatage" wrote:
> >
> > > Have you set up any user roles and permissions in NAv?
> > >
> > > "Wing" wrote:
> > >
> > > > Dear ALL,
> > > >
> > > > Dynamic NAV 5.0 SP1, SQL 2005.
> > > >
> > > > I have created a Windows Authentication user (Member of Domain User);
> > > > On SQL Server, Assign this Windows Authentication user to "Public" Server
> > > > Role.
> > > > And then Add this Windows Authentication user to Nav.
> > > >
> > > > The question is After this Windows Authentication user login to NAV, this
> > > > user can click "Database => New" to create New Database on SQL Server, How
> > > > come??
> > > >
> > > > Which setup is missing??
> > > >
> > > > Thanks.
> > > > Wing
> > > >
> > > >
> > > >
 | 
Pages: 1
Prev: NAVISION FOR ACCESS DETAILS
Next: Workflow Management Addon