Cannot delete user in native server database

EjvdB · 2017-04-06

We have entered a database user with an empty userid, with only the name filled in. (NAV2009sp1, native server) The user never logged in. Now I try to delete this user but every attempt results in a hanging client. Tried to delete via form, codeunit, report, but nothing works. Can anyone please help me out here?

vaprog · 2017-04-07

Check your database (from the menu select File | Database | Tables . Select all tables, then click Test. Select all options except Test field relationships between tables. In the Options tab select File.
If no error turns up here, try to delete the user with no other user logged in, not even NAS, and only one database server accessing the database.

kriki · 2017-04-07

Wild guess: try first to rename it.

vaprog · 2017-04-07

Check your database (from the menu select File | Database | Tables . Select all tables, then click Test. Select all options except Test field relationships between tables. In the Options tab select File.
If no error turns up here, try to delete the user with no other user logged in, not even NAS, and only one database server accessing the database.

EjvdB · 2017-04-08

The database check did not give any errors. I managed to delete the user, but only after i was the only logged in user and even the database server was ended. Thanks Kriki and vaprog for your suggestions.

Cannot delete user in native server database

Best Answer

Answers

Categories