Granted delete,insert,select,update and view defintion to a user on all the tables in a database,I can see all the above permissions checked in the explicit permissions but when I look at the effective permissions for this particular user all I can see is
select and view definition .No idea what went wrong.
Right now user couldnt delete or insert into the table.
this is a bit urgent as entire work is on hold .Please help
Let me know if I am not clear.
...
Go to the complete details ...