• Granting SELECT on a view does exactly that. It doesn't revoke any other permissions that the user already has. Query sys.database_permissions to find out what those permissions are.

    John