User doesn't get the appropriate rights
Hi,
I tried to create another user in a SQLServer database. I used the sa account of SQLServer and I selected 'Create SQL Server Login and User'.
After creation I grant the user a role which has access on the appropriate security groups. The user can see all the information he is supposed to see but when he tries to create an entry he gets the following message:
Can it be that something goes wrong with the grants when you create a new user?
Is there a workaround?
Kind regards,
Peter
All Comments (8)
Hi
This is at the heart of our security system, Its possible there's a bug, but we would have received a ton of bug reports
Can you go in Help - View Application Log on the workstation you used to create the user, try to find a relevant error message.
Can you delete it and recreate it? You should have a notice that the user already existed and that the password could not be set, but that's what we would expect.
Maurice