Re: Preventing unauthorized access
From: Dandy Weyn (mct_at_dandyman.net)
Date: 11/17/03
- Next message: Andrew J. Kelly: "Re: User/Role gets lost at Restore Time."
- Previous message: jason: "access across domains"
- In reply to: Sydney Lotterby: "Preventing unauthorized access"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Mon, 17 Nov 2003 23:21:35 +0100
Why not using application roles, activate the application roles from within
the applications, only apply permissions to the application role.
Dba's will still be able to access the data, offcourse permissions need to
be set on the corresponding objects, no matter if it is a stored procedure
that needs execute permission or a table that needs select permissions.
Regards,
Dandy Weyn
MCSE, MCSA, MCDBA, MCT
"Sydney Lotterby" <sydney@infosearch.com> wrote in message
news:OC2fa5RrDHA.3844@tk2msftngp13.phx.gbl...
> (SQL7/2K)
> I have several dbs that I don't want anyone to open up in either
Enterprise
> Mgr, QA or an app that they might write. In short I don't want anyone to
> see the structure or contents of the dbs other than via my app. How can
> this be done simply?
>
> tia
>
>
- Next message: Andrew J. Kelly: "Re: User/Role gets lost at Restore Time."
- Previous message: jason: "access across domains"
- In reply to: Sydney Lotterby: "Preventing unauthorized access"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
