Hey thanks K.
> -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Monday, August 12, 2002 10:00 AM > To: CF-Community > Subject: Re: RE: sql server 2k table ownership > > > 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(r) SQL Server(tm) user or role, or Microsoft > Windows NT(r) 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. > > > > > > > > > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
