July 8th, 2008, 08:57 AM
|
|
Registered User
|
|
Join Date: Jul 2008
Posts: 3
Time spent in forums: 28 m 17 sec
Reputation Power: 0
|
|
|
Grant permissions on database
Hey, I need to grant permissions on a database programmatically. Previously I was setting the owner of the database manually for the permissions but now I need to do it on install through SQL statements. There are 14 tables in the database and I need SELECT, INSERT, UPDATE on all of them. Is there a way to grant these permissions on the database or do only tables accept them? If I can't do that how do I set the owner of the database to a certain user through SQL?
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
