Re: Securing Data

You can secure it any way you like. I'd go with the one DB and simply grant
as required. By default, non-DBO's have no access anyway.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"Bruce Martin" <bmartin@xxxxxxxx> wrote in message
news:u%23xisT8OGHA.3944@xxxxxxxxxxxxxxxxxxxxxxx
I got the job of DBA handed to me since I talk DB2 on mainframes. Anyway we
have a SQL2K with maybe 12-14 users, using WinNT auth. to log on. We are
going to getting some data that only certain folks can see. We have 2
restricted tables in one of our databases right now and access is controlled
by denying access to certain users. I have suggested that we should created
a secured data base and only allow the cleared folks to access it. Is this
the best way to attack this problem, or should we do something else.

Thanks guys/gals


Bruce


.

Relevant Pages

  • Re: Securing Data
    ... SQL Server MVP ... Columnist, SQL Server Professional ... a secured data base and only allow the cleared folks to access it. ...
    (microsoft.public.sqlserver.security)
  • Secure access to a SQL Server database
    ... securely accessing SQL Server. ... script text, computer launched from, user launching. ... the hash value that gets authenticated against the secure table. ... ASP Currently we use SQL Server authentication and stuff something in a ...
    (microsoft.public.sqlserver.security)
  • Re: Best method of saving data between the normal and SSL stuff
    ... I would use a central SQL Server to host both secure and non-secure data. ... > What I want to do is store their completed orders so that they can look at ... > to same http 'hit' DB? ...
    (microsoft.public.inetserver.asp.db)
  • Re: How to prevent my stored procedure code from being decrypted?
    ... > How should I do to secure my code? ... the primary way to protect intellectual property is with license ... this alias are considered for inclusion in future versions of SQL Server. ... > I found some freewares which can decrypt the encrypted stored procedure. ...
    (microsoft.public.sqlserver.security)
  • Re: [Full-disclosure] Database servers on XP and the curious flaw
    ... that by default it's secure. ... received at least 3 emails that have pointed this out that SQL server is ... running database servers on their system. ... >>well if the configuration allows the guest account access to the database. ...
    (Full-Disclosure)