Need to change permissions on db objects

[NagsHead]

I have sql server space on a paid providers server. I only have limited permissions and don't know alot about sql server administration. I need to change the ownername/password on my account, which I will have to do through tech support. They told me they can change it, but that there could be permissions problems. They said I could change the permission with a query, but I don't know the syntax for this query. Pardon my ignorance please, but any help here would be greatly appreciated.

 

[dickiebird]

In a script :
isql -U$DB_USERID -P$DB_PASSWD << END
Grant Execute On Your_proc_name To Your_Username_list
go
END

or just the line starting &quot;grant&quot;, when in an isql session

HTH Dickie Bird (-)))

 

[NagsHead]

Thank you mr. bird

I was hoping to try this out this weekend but haven't had a chance yet. I'll post again when I do.