Re: how could i hide my finacial data to sa when i store them in sql server 2k?

From: Uri Dimant (urid_at_iscar.co.il)
Date: 09/06/05

  • Next message: Ivan: "Security problem of Transfer Login Task" 
    Date: Tue, 6 Sep 2005 09:42:24 +0300

    Hi
    Where does the info reside? One or many tables?
    You can adde the user to db_denydatareader role and make sure that he/she is
    not a member of sysadmin server role.

    "xuyan" <microsoft.net@sina.com> wrote in message
    news:eRfUysosFHA.3404@TK2MSFTNGP09.phx.gbl...
    > what we store in db is informatin about company finacial status.
    > we don't want anyone in charge of the server can read the those data.
    > what can i do without 3rd party software like activecrypt?
    >
    > thank you.
    >
    >

  • Next message: Ivan: "Security problem of Transfer Login Task"

    Relevant Pages

    • Re: Problems creating subscription...
      ... The distribution agent job has been implicitly created and ... 'ROUSES.COM\LarryDSI' is a member of sysadmin server role and cannot be ... granted to or revoked from the proxy. ...
      (microsoft.public.sqlserver.replication)
    • Re: GK - Granting on all objects but not on JOBs ?????
      ... You have to be member of SYSADMIN server role or member of DB_OWNER role ... in MSDB database. ... procedures etc) and NOT on JOBs? ...
      (microsoft.public.sqlserver.security)
    • Re: Executing Jobs via a SQL Statement
      ... Note that you still need to be the owner of a job or a member of the ... sysadmin server role to start jobs with sp_start_job, ... SQL Server MVP ...
      (microsoft.public.sqlserver.dts)
    • Re: Basic Server Roles (security) question
      ... Are you member of sysadmin server role as well? ... > I want to add a consulting firm of ours to have full access to a ... > nothing I can find talks about this kind of granularity in security. ...
      (microsoft.public.sqlserver.security)