Hi
The books online says "sp_helprotect does not return information about
securables that are introduced in SQL Server 2005."
The result set of "exec sp_helprotect null, dbo" contains
Owner Object Grantee Grantor ProtectType Action Column
. . dbo dbo Grant CONNECT .
But as per the documentation "sp_helprotect" should not return information
about securables which are introduced in SQL Server 2005.
Any idea why sp_helprotect gives this results?
Are there any other things like the document says something but the actual
results are different?
Re: DBO Best Practices ... lines of always owner qualifying objects...... someone who are just "a" dbo.... > doesn't explicitly reference the object's owner (because SQL Server will ... The startup account defines the ... (microsoft.public.sqlserver.security)
Re: DBO Best Practices ... If you let DBO own databases or objects then regular ... Please note that the DBO user is identified by the SQL Server process... the SQL Server startup account (for the ...SQL Server process) controls SQL Server's ability to work with NT's objects ... (microsoft.public.sqlserver.security)
Re: ASP.net insists on using dbo. to call aspnet_* stored procedures ... No. mysql_login is one account and the dbo is another account, ...SQL Server 2000 developer in same machine. ...connection string is setup to use the sql login assigned to the ... (microsoft.public.dotnet.framework.aspnet)
Re: ASP.net insists on using dbo. to call aspnet_* stored procedures ... dbo is the schema used in SQL Server and, even if removed from queries, is technically still there. ... It sounds more like a permissions error or connectivity problem than a dbo problem.... Is SQL Server on the same box as your application? ... the remote server once again, but I still get errors like this: ... (microsoft.public.dotnet.framework.aspnet)
Re: User names ... > With SP3 will tables created by upsizing from access also be dbo owned as ...>>dbo by default. ... byjust specifically giving the owner name in QA. ... >> SQL Server MVP... (microsoft.public.sqlserver.server)
