Posted by Erland Sommarskog on 08/09/06 21:30

Ward Bekker (ward@NospaaMequanimity.nl) writes:
> Hi Erland,
>
> Thanks for the tips!
>
> We are running SQL Server 2005.

In that case you should grant CONTROL on the dbo schema for the database
user. Maybe they are creating other scheams, but then they need to include
GRANTs for that.

You should also use

select name, is_trustworthy_on, is_db_chaining_on
from sys.databases

to make sure that the databases are not marked as trustworthy, or available
for DB-chaning.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Using Union and Join in a single view
• Prev in forum: Re: Tying together tables
• Thread view: Re: How to restrict evil create scripts?

[Reply to this message]