Hi Lowel..

You are correct. Everyone looks for an easy method. Now in my case i should give admin for almost all databases and restrict for only some tables in few databses. So i was thinking of any easy method of doing it. But its not possible i think. So now i have to give db_owner for the database for which i want full permission(admin permission) and i have to create roles for only database for which i have to restrict the access.Also in server roles i can give only "public" permission. Is that correct?