problem with Database Login(Urgent)

devu_13

Hi Experts
By mistake super users permission will changed.i cant enter in database with any USER ID. can you give any way to enter in Database. Thank you

kine

SQL or Native?

devu_13

kine wrote:

SQL or Native?

This Problem in SQL not in Native.

garak

if you are under SQL you have the option to open the database on SQL Server Management Studio as dbowner or sysadmin.
Then open the table "Member of" (if you have change the permissions in the database logins) and search for the user super or for your database admin account. Give them there the RoleID SUPER. now open Navision with the database login super (or you database admin).
now you can set the permissions new for the other users.

If you use windows login, open the table "Windows Access Control" and set there the Role id

Regards

devu_13

Thanks

garak

No problem, but please use in future other Subject instead of "(Urgent)".

so, welcome