hi !
what is difference between dbo user and another user?
Look in the BOL for mre information:
"Database Owner (dbo)
The dbo is a user that has implied permissions to perform all activities in the database. Any member of the sysadmin fixed server role who uses a database is mapped to the special user inside each database called dbo. Also, any object created by any member of the sysadmin fixed server role belongs to dbo automatically."
HTH, Jens Suessmeyer.
|||In generic terms DBO user has all privileges against the database andSQL server and normal users privileges can be controlled by setting proper roles against it.Read thru books online for DBO and security for more information.
http://www.sqlsecurity.com is a good website to catchup security information.
No comments:
Post a Comment