dbo and permissions? - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Administration

dbo and permissions?

Author

Topic

mdean9999
Starting Member

21 Posts

Posted - 2011-05-27 : 13:11:20

I have an old SQL server database now running in sql server 2008. There are four tables prefixed 'dbo.' and the rest are 'SFS.'.
How do I change change the four to the same as the rest? Or do I not need to bother?
I don't fully understand what the ramifications of this 'database owner prefix' are!

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2011-05-27 : 14:10:26

If nothing is consuming this database then you can probably do as you want but otherwise I wouldn't mess with it until you know what you're doing and why.

Here's some general info:
SQL Server Best Practices – Implementation of Database Object Schemas

To change the schema of a table use alter schema

Be One with the Optimizer
TG

InfraDBA
Starting Member

38 Posts

Posted - 2011-06-06 : 00:56:55

Check with the application that is accessing the database.Check with the default schema for the database and then do the changes.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources