How to disable the File->Database->New option

Klau
Klau Member Posts: 15
edited 2012-10-14 in NAV/Navision Classic Client
Hello there,

I need your help about creting roles & permissions in NAV. I do not want the user to use 'File --> Database --> New', is there a way to enable/disable?

Please let me know

Klau

Comments

  • matttrax
    matttrax Member Posts: 2,309
    I don't remember the exact number, but just enter System as the type and do a lookup in Roles --> Permissions. If there is one you should see it.
    Matt Traxinger - ArcherPoint
  • slmaluwa
    slmaluwa Member Posts: 366
    But, do you think it will work?
    I think the permissions get activated only after logging in and the user can always create a NEW (native) database without first logging into another DB???

    Willing to learn more on this line!
    "A bove maiore discit arare minor"-"From the old ox, the young one learns to plow."
  • kine
    kine Member Posts: 12,562
    There is no way. There is one question - Why?
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • garak
    garak Member Posts: 3,263
    native or sql?
    Do you make it right, it works too!
  • Divya
    Divya Member Posts: 125
    1. Goto Roles --> Permission --> Delete System 0 Yes Yes Yes Yes

    2. Select permission as follow as

    System 2510 Edit, Find Yes Yes Yes Yes Yes
    System 2520 Edit, Replace Yes Yes Yes Yes Yes
    System 3220 View, Table Filter Yes Yes Yes Yes Yes
    System 3230 View, FlowFilter Yes Yes Yes Yes Yes
    System 3410 View, Sort Yes Yes Yes Yes Yes
    System 3510 View, Design Yes Yes Yes Yes Yes
    System 5830 Tools, Security, Password Yes Yes Yes Yes Yes

    3. Syncronize the specific login and check.. it will work...
    Victory is sweetest when you've known defeat
  • kine
    kine Member Posts: 12,562
    Divya wrote:
    1. Goto Roles --> Permission --> Delete System 0 Yes Yes Yes Yes

    2. Select permission as follow as

    System 2510 Edit, Find Yes Yes Yes Yes Yes
    System 2520 Edit, Replace Yes Yes Yes Yes Yes
    System 3220 View, Table Filter Yes Yes Yes Yes Yes
    System 3230 View, FlowFilter Yes Yes Yes Yes Yes
    System 3410 View, Sort Yes Yes Yes Yes Yes
    System 3510 View, Design Yes Yes Yes Yes Yes
    System 5830 Tools, Security, Password Yes Yes Yes Yes Yes

    3. Syncronize the specific login and check.. it will work...

    In which database? And it will work even if you open client and you will not login into any database? ;-)

    This cannot be done thorugh any permissions, because permissions are conencted to some DB, but creating new DB is no connected to any other DB because in time you are creating new DB, you are not logged into some DB with permissions to disable this... :whistle:
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • Sog
    Sog Member Posts: 1,023
    But if you're running on sql you can alter the permissions there.
    But the question remains, why?
    There is no reason why a user would create a db on their own.
    Unless the users are children.
    |Pressing F1 is so much faster than opening your browser|
    |To-Increase|
  • kine
    kine Member Posts: 12,562
    Yes, it is like permit creating new folder with name "New folder" or to create new document within MS Word because else user will have many empty word files in his folder... :mrgreen:
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • DenSter
    DenSter Member Posts: 8,307
    If users only get the public role on SQL Server, just like the recommendations, they shouldn't be able to create a new database.
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • garak
    garak Member Posts: 3,263
    CREATE DATABASE permission defaults to members of the sysadmin and dbcreator fixed server roles. Members of the sysadmin and securityadmin fixed server roles can grant CREATE DATABASE permissions to other logins. Members of the sysadmin and dbcreator fixed server role can add other logins to the dbcreator role. CREATE DATABASE permission must be explicitly granted; it is not granted by the GRANT ALL statement.

    CREATE DATABASE permission is usually limited to a few logins to maintain control over disk usage on the computer running SQL Server.
    So, if the user is in the role public, they can't create a database.
    Do you make it right, it works too!
  • kine
    kine Member Posts: 12,562
    But they can on their own SQL Express installed on their PC etc. It means, you can permit where they can create the database, but you cannot do that in general in the client. 8)
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • Divya
    Divya Member Posts: 125
    If u need to disable File-->Database-->New option without opening any database means.. You have to do the role setups in the SQL Server.

    Open SQL Server Login Properties (by right click on the Login). Select "Server Roles" --> "Database Creators" --> You should uncheck this..

    Even no need to check anything in the server roles. You just have to give Database Access for the specific database.

    Definitely it will work.. why because i have implemented same in my client place too..
    Victory is sweetest when you've known defeat
  • garak
    garak Member Posts: 3,263
    kine wrote:
    But they can on their own SQL Express installed on their PC etc. It means, you can permit where they can create the database, but you cannot do that in general in the client. 8)

    Hehe :mrgreen: thats right, but you can permit it on the main server or test server ....
    Do you make it right, it works too!
  • sudhakarsv
    sudhakarsv Member Posts: 100
    Divya
    If u need to disable File-->Database-->New option without opening any database means.. You have to do the role setups in the SQL Server.

    Open SQL Server Login Properties (by right click on the Login). Select "Server Roles" --> "Database Creators" --> You should uncheck this..

    Even no need to check anything in the server roles. You just have to give Database Access for the specific database.

    Definitely it will work.. why because i have implemented same in my client place too

    How can we disable this permission of creating new database with classic ?
    You help regarding this is highly appreciated.
    Regards,
    S.V.Sudhakar
  • kine
    kine Member Posts: 12,562
    You mean Native DB? You cannot... why you want?
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • bbrown
    bbrown Member Posts: 3,268
    Exactly what problem are you trying to solve? I know you say you want to prevent a user from creating databases. But why? If you've setup your system properly, then no non-admin user wil be able to create a database on the server (native or SQL). Yes, they could create one locally on their own workstation. But would that create a problem?
    There are no bugs - only undocumented features.

Categories