how to grant select access my sql server when I exec the syntax to gain the access I get an error that I cant grant permissions  to my self. 
any Ideas please!
It does not make sense to be changing your own rights.   If you already have rights you do not need to grant them. If you do not have the desired rights, you should not be able to grant them to yourself.  (Nor should you be able to deny yourself rights.)

However, it is possible that you apparently should have rights to some object, but you do not.  In that case, check to see if your account was directly denied access to that object or if you are in a group or role that has been denied access.  DENY always overrides a GRANT.

Just to flesh out the limits to changing permissions, there are other rights that cannot be changed, such as:


sa - operates outside the security system, can do everything on the server
dbo - can do everything in the database 
entity owner - owns an object or objects and therefore has full rights to them
information_schema - system defined ownership 
sys - system defined ownership


More:  If you are an administrator and a group membership is denying you rights, you may be able to modify the group's rights or its membership.  Otherwise, you need someone with GRANT rights to assist you.