Super without backup and export of object

andy76

Hello,

I ask you if there is a method to allow 1 user to be a SUPER to be able to develop but without possibility to backup the database and export the objects.
We are using NAV 5.0 with database SQL.

I ask you this that seems strange but it is before we are working with external consultants and do not want that they keep our objects and data.

Thank you very much

JedrzejT

Hello,

Just create new role (super 2.. or something)
Copy all permission from role SUPER.
Delete System 0 permission.
Add all System permission with Yes permission in execute without those 2 that You mention

Add this new role instead of standard super for those User.

andy76

Thank you but could you explain better this sentence:

Add all System permission with Yes permission in execute without those 2 that You mention

?

andy76

Probably I have understood what you mean.

kine

Of course, still, the developer needs to have some additional permissions on the SQL to be able to modify the tables... and this could give him access outside NAV to the DB on SQL (e.g. through Enterprise Manager)