SQL rights for SPS
Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance
Date: Thu, 24 Jun 2004 11:13:32 -0700
Once the database is created and connected to SPS2003, can
the SQL account be demoted to DBO?
We have SQL on a server with other databases, and cannot
give SA rights to the account on a permanent basis.
Relevant Pages
- Re: Changing DBO
... You need to first change the ownership of the existing objects to 'dbo' ... You can then remove the existing database user ... > I have assigned an SQL account as DBO of a database. ...
(microsoft.public.sqlserver.security) - Re: How to prevent DELETEs in a table
... It is the dbo database USER, not server-level groups, that determins ... It has implicit permissions that can not be denied. ... SQL Server just skips any permission validation for sysadmins. ...
(microsoft.public.sqlserver.server) - Create SharePoint Portal failed.
... One mentioned ensuring that SQL Server uses a case ... 13:55:40 Service database server is 'USDC-JOHRIV'. ... Update dbo.propertylist set DisplayName = N'Last name' ...
(microsoft.public.sharepoint.portalserver) - Re: conflicting object names in sql server 2000
... On the local database server when it does the select * from ... > michael.xxx Note that michael is the owner of the database. ... it will see if there is one owned by dbo. ...
(microsoft.public.sqlserver.server) - Re: ADO Connection Timeout
... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
(microsoft.public.data.ado) |
|
