What kind of object is is SP_Logging? If it is a view or table, you should be able to grant select permission, assuming you have the privileges to grant such permissions. If it is a stored procedure (which it may be - many people prefix stored procedure names with a "sp" (which is not a good practice - but that is for another day), then grant execute rather than grant select.

Another possibility is that SP_Logging might be in a schema different from the default schema. If so, you will need to prefix the schema name. You can find the schema name (among other things) from INFORMATION_SCHEMA.TABLES and INFORMATION_SCHEMA.VIEWS

I thought I wrote a reply a while ago, but I think the dog must have eaten it. You don't need to grant select permissions explicitly if you have added the user to the db_datareader role. You can see the permissions that can be granted on each type of object here: http://msdn.microsoft.com/en-us/library/ms191291.aspx.

If you want to give access to every object I don't know of a way to grant that other than grant on each object, or give db_owner database role or sysadmin server role.

I thought I wrote a reply a while ago, but I think the dog must have eaten it. You don't need to grant select permissions explicitly if you have added the user to the db_datareader role. You can see the permissions that can be granted on each type of object here: http://msdn.microsoft.com/en-us/library/ms191291.aspx.

If you want to give access to every object I don't know of a way to grant that other than grant on each object, or give db_owner database role or sysadmin server role.