>From Books Online: sp_changeobjectowner (T-SQL) Changes the owner of an object in the current database.
Syntax sp_changeobjectowner [@objname =] 'object', [@newowner =] 'owner' Arguments [@objname =] 'object' Is the name of an existing table, view, or stored procedure in the current database. object is nvarchar(517), with no default. object can be qualified with the existing object owner, in the form existing_owner.object. [@newowner =] 'owner' Is the name of the security account that will be the new owner of the object. owner is sysname, with no default. owner must be a valid Microsoft� SQL Server� user or role, or Microsoft Windows NT� user or group in the current database. When specifying Windows NT users or groups, specify the name the Windows NT user or group is known by in the database (added using sp_grantdbaccess). Return Code Values 0 (success) or 1 (failure) Remarks The owner of an object (or the members of the group or role owning the object) has special permissions for the object. Object owners can execute any of the Transact-SQL statements related to the object (for example, INSERT, UPDATE, DELETE, SELECT, or EXECUTE) and can also manage the permissions for the object. Use sp_changeobjectowner to change the owner of an object if the security account that owns the object has to be dropped but the object must be retained. Use sp_changedbowner to change the owner of a database. Permissions Only members of the db_owner fixed database role, or a member of both the db_ddladmin and db_securityadmin fixed database roles can execute sp_changeobjectowner. Examples This example changes the owner of the authors table to Corporate\GeorgeW. EXEC sp_changeobjectowner 'authors', 'Corporate\GeorgeW' ----- Original Message ----- From: "Cantrell, Adam" <[EMAIL PROTECTED]> Date: Monday, August 12, 2002 8:58 am Subject: RE: sql server 2k table ownership > ps. all dbo tables were imorted from access. All the new tables > since then > were created via enterprise manager. hmmm. > > Adam. > > > > -----Original Message----- > > From: Cantrell, Adam [mailto:[EMAIL PROTECTED]] > > Sent: Monday, August 12, 2002 9:55 AM > > To: CF-Community > > Subject: OT: sql server 2k table ownership > > > > > > Sorry for the monday morning OT, but I have a small annoyance > > where some of > > my tables are owned by 'dbo'; and some of my tables are owned > > by the user I > > created for my ColdFusion odbc dsn. All of the tables are > > accessible just > > fine, but when they're displayed in CF studio using RDS, it > > sorts them by > > the owner and then by name. All the dbo tables show up, and > > then the custom > > user tables. > > > > Does anyone know how to change the ownership of a table in SQL > server?> Looked through the books for about 30 minutes this > morning, > > maybe somebody > > can help me out. Thanks. > > > > Adam. > > > > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
