I tried the two table method of security permissions but I am getting an error message

So here is my setup.

MSSQL Employee table.

MSSQL Employee Permissions table.
image

You can see I’m listed as an Admin.

Now, I have setup users & permissions with just one role to keep it simple.

When Restrict is left blank, I can run the server action.
image
image
image

When I set Restrict to Admin, I get an error.
image
image

Server Model is ASP.NET
image

IIS
image

Thanks
Ray.

Community Page
Last updated: