Re: security problem
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Mon, 12 Feb 2007 23:10:28 +0000 (UTC)
Roy Goldhammer (roy@xxxxxxxxxxx) writes:
i have application written on magic that use sql server 2005 as database.
What is "magic"
when i only set mapping and db_owner role it still brings an error of
permissions.
What error message do you get exactly? And what is that mapping you are
talking about?
Only when i set each permission action on the security window to be true
it allows the users to have all permissions on the database.
What security window? Is that something in "magic", or something in your
application?
For my knolwlage db_owner is the top permission which allows everything.
But it doesn't seem to me to be a good idea to let all users have db_owner
rights.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
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
.
- Follow-Ups:
- Re: security problem
- From: Roy Goldhammer
- Re: security problem
- References:
- security problem
- From: Roy Goldhammer
- security problem
- Prev by Date: security problem
- Next by Date: Re: Need help on how to organize users and objects
- Previous by thread: security problem
- Next by thread: Re: security problem
- Index(es):
Relevant Pages
|
