Petri.com forums Home Forums Start Page Forums Frequently Asked Questions FAQ Member List Members List
Go Back   Petri IT Knowledgebase Forums > Microsoft BackOffice > SQL Server 2005 / 2008 / 2008 R2 / 2012
Petri.com is happy to award RicklesP the title of Most Valuable Member !!!
Register Calendar Calendar Search Petri IT Knowledgebase Forums Search Todays Posts Today's Posts Mark Forums Read
Notices

db owner security issue

db owner security issue

this thread has 2 replies and has been viewed 2664 times

Closed Thread
 
Thread Tools Search this Thread Display Modes
  #1  
Old 5th February 2012, 16:05
bustanji83 bustanji83 is offline
Junior Member
Staying around
 
 Join Date: Jul 2008
  6 month star 12 month star
 Posts: 214
  Send a message via Yahoo to bustanji83
 Reputation: bustanji83 is an unknown quantity at this point (8)
Exclamation db owner security issue

How can i give some one db-owner permissions without backup
but when i deny backup he can change it to grant.

how can i prevented this issue
  #2  
Old 5th February 2012, 19:00
Lior_S's Avatar
MVM Lior_S Lior_S is offline
Member
MVM
 
 Join Date: Aug 2006
  6 month star 12 month star
 Location: USA
 Posts: 947
 Reputation: Lior_S is a jewel in the roughLior_S is a jewel in the roughLior_S is a jewel in the rough (278)
Default Re: db owner security issue

That is like giving someone a house, making him responsible for renovations, he can move furniture in and out, even sell it. But cannot copy the house key.
__________________
"...if I turn out to be particularly clear, you've probably misunderstood what I've said” - Alan Greenspan
  #3  
Old 6th February 2012, 09:26
bustanji83 bustanji83 is offline
Junior Member
Staying around
 
 Join Date: Jul 2008
  6 month star 12 month star
 Posts: 214
  Send a message via Yahoo to bustanji83
 Reputation: bustanji83 is an unknown quantity at this point (8)
Default Re: db owner security issue

ok i was create a role on databse and add the user to this role but not work
Closed Thread


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Moving file to root drive erases owner and security permissions TheGeek SBS 2000 / 2003 / 2008 / 2011 2 17th August 2011 00:21
Wi Fi Security Issue kathy General Security 12 13th October 2008 03:24
DFS security issue. JDMils Active Directory 1 9th October 2008 08:19
Security issue?! Killerbe Terminal Services 7 26th September 2008 20:09
OWA Security Issue Boomer Exchange 2000 / 2003 1 19th September 2006 23:51


All times are GMT +3. The time now is 12:30.

Steel Blue 3.5.4 vBulletin Style ©2006 vBEnhanced
Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
 

Valid XHTML 1.0!   Valid CSS!

Copyright 2005 Daniel Petri