Changing all database table’s owner to DBO

home
database
view story

1 Kicks

Changing all database table’s owner to DBO(www.diaryofaninja.com)

submitted by wiredone(917) 2 years, 2 months ago

One of the niggling that often happens when your deployed to a cheap shared hosting environment is having your table owners change on you. If you have created a data access layer that references tables using their long name this is an issue. This can be caused by a deployment script not maintaining user permissions on your tables or maybe you’re using a web console to interract with you database like myLittleAdmin and it doesn’t allow you to create a table under any user but your own.

add a comment |category: Database |Views: 8
Tweet