I need to install a sandboxed solution to my site (SPWeb). However I am not a site collection administrator, and therefore cannot access the solution gallery that exists at the site collection level. I am a site (SPWeb) administrator though. How can I deploy my solution on the site (SPWeb) that I am admin of? Or do I have to ask the site collection admin to upload my .wsp to the site solution gallery for me?
You'll need to ask a Site Collection Admin to upload it for you if you don't have the right permission.
A sandboxed solution is installed by a site collection administrator to the site collection's solution gallery. This gallery also shows the current resource usage, average resource usage over the past two weeks, and the status of each sandboxed solution.