Hi All,
Please could you help me. I added a new user and deleted two users on Friday using the security wizard then modified a DB. When I tried to open one of my DB this morning I was not prompted to enter user name and password as normal just DB password then an error message came up that 'I did not have the necessary permissions to use the DB and have the administrator or person who created this object set the necessary permissions for you'. I am the administrator for all my DBs (I have 5 in total). The DB are stored on a network and IT restored my DBs from previous night and this still has not worked is there any way of fixing this I have ten years worth of data in some of these DBs.
Many thanks in advance