ZSBD 5

of the role. Only members of the sysadmin fixed server role, or the

db_securityadmin and db_owner fixed database roles, or the role owner can

execute sp_addrolemember to add a member to a user-defined database role.

sp_droprole Drops a SQL Server role from the current database

sp_droprolemember Drops a security account from a SQL Server role

If objects were not created with the dbo user as the object owner, you can

change the object owner by using the sp_changeobjectowner system stored    ,    -    , . / ,

procedurę.    t j    Są

sp changeobjęnł^wner object, owner Z&jot/DtboUul usU* cJi^eudu drutuje' Consider the following facts about changing database object ^ owners:    O&ćł/Ui

□    Only members of the db_owner and db_ddladmin fixed database roles and

members of the securityadmin server role can change database

object

owners.

□    Changing the owner of a database object requires that you directly update

all Scripts and batch files that reference that object to include the new

ownership information. SQL Server cannot perform this update automatically.