Hi All,

I gave the following.

1. grant connect to "sample";
2. grant select on "Admin".bases to "sample" as "Admin";

I suppose to give only the connect permission but I gave the second one also. I want to revoke the second one, Please suggest me how to revoke the "grant select on "Admin".bases to "sample" as "Admin";"

Thanks

In fact I have to revoke the access for
grant insert on "Admin".bases to "sample" as "Admin";

Like this I have given lots of insert , delete , update. I have to revoke every think. Only I have to give the connect permission.