Computing.Net > Forums > Windows 2000 > SQL user permissions

Specialty Forums
Security and Virus
General Hardware
CPUs/Overclocking
Networking
Digital Photo/Video
Office Software
PC Gaming
Console Gaming
Programming
Database
Web Development
Digital Home

General Forums
Windows XP
Windows Vista
Windows 95/98
Windows Me
Windows NT
Windows 2000
Win Server 2008
Win Server 2003
Windows 3.1
Linux
PDAs
BeOS
Novell Netware
OpenVMS
Solaris
Disk Op. System
Unix
Mac
OS/2

Drivers
Driver Scan
Driver Forum

Software
Automatic Updates

BIOS Updates

My Computing.Net

Howtos

Site Search

Message Find

Data Recovery

About

SQL user permissions

Reply to Message Icon
Original Message
Name: shrenik
Date: November 27, 2002 at 22:20:34 Pacific
Subject: SQL user permissions
OS: Windows 2000
CPU/Ram: PIII 256 MB RAM
Comment:

Hi

I am facing a problem with SQL server security settings. When I create a new SQL server user and grant him default database. He is able to change his database properties like quota etc which I should not happen and ideally he should get only the readonly permission to the database properties.
While creating the database user I make it sure that he does not have access to master database. This user has been assigned the role of db_owner for his database only.
I want that the db_owner should not be able to change his own database properties.
Thanks in advance.

Shrenik



Report Offensive Message For Removal







Use following form to reply to current message: 

   Name: From My Computing.Net Settings
 E-Mail: From My Computing.Net Settings

Subject: SQL user permissions

Comments:
         

 


  Homepage URL (*): 
Homepage Title (*): 
         Image URL:
 
Data Recovery Software



dvi to vga

ftp transfer in visual basic 5

i cant open my local disc C

please help Upgrading my video card

Flash Video Recorder

All Posts Awaiting Replies