Re: Deny Create Database
From: Tom Moreau (tom_at_dont.spam.me.cips.ca)
Date: 02/12/04
- Next message: Rich: "RE: Location of the Audit Log"
- Previous message: Scotty: "Deny Create Database"
- In reply to: Scotty: "Deny Create Database"
- Next in thread: Scotty: "Re: Deny Create Database"
- Reply: Scotty: "Re: Deny Create Database"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Thu, 12 Feb 2004 11:11:02 -0500
Run:
use master
before you run the DENY.
-- Tom --------------------------------------------------------------- Thomas A. Moreau, BSc, PhD, MCSE, MCDBA SQL Server MVP Columnist, SQL Server Professional Toronto, ON Canada www.pinnaclepublishing.com/sql "Scotty" <scasti1@cox.net> wrote in message news:4B307CF8-97A3-41ED-9F3E-ABB130C8C525@microsoft.com... User is an NT Administrator and has been made a member of Server Role sysadmin. I'm not in the master database in query analyzer. When I do this: Deny Create Database To User I get the following message: CREATE DATABASE PERMISSION CAN ONLY BE GRANTED IN THE MASTER DATABASE How do I alter the SQL statement to refer to the master database? Thanks for any help.
- Next message: Rich: "RE: Location of the Audit Log"
- Previous message: Scotty: "Deny Create Database"
- In reply to: Scotty: "Deny Create Database"
- Next in thread: Scotty: "Re: Deny Create Database"
- Reply: Scotty: "Re: Deny Create Database"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
