Database Security

From: Paul (p_amarant_at_hotmail.com)
Date: 06/18/03

  • Next message: ~: "Re: backup set / backup media password protection" 
    Date: Wed, 18 Jun 2003 14:40:04 -0700

    Put the database in single user mode. Used when you are
    doing maintenance procedures.
    >-----Original Message-----
    >Hi All,
    >
    >We have recently implemented a new payroll system that is
    >backed by a sql database. For payroll purposes there are
    >3 seperate databases, one of which is for directors only.
    >We can lock down access to this information from within
    >the payroll system itself, however many of our users make
    >use of crystal reports, and could effectively use this to
    >access the content of this database. Is it possible to
    >lock down the SQL Database such that only one person (the
    >FD) can access it.
    >
    >Many thanks
    >
    >Ian
    >.
    >

  • Next message: ~: "Re: backup set / backup media password protection"

    Relevant Pages

    • Re: Database Security
      ... You don't say how the users are connecting via the payroll system. ... >backed by a sql database. ... >lock down the SQL Database such that only one person (the ...
      (microsoft.public.sqlserver.security)
    • Re: Parameterization of Object Models
      ... Lock down Access to the system -- ... Attempt to prevent deadlocks see The Concepts of Database Management, ... recovery; that is, you say that you recovered the database. ... database (called a backup or a save). ...
      (comp.lang.misc)
    • Re: db maintanence plan failure
      ... Maint wiz has an option to create a report file for each execution. ... trying to set the database in single user mode, ... users connected to the database. ... split into 2 seperate jobs when I look at the Jobs node under SQL Agent. ...
      (microsoft.public.sqlserver.server)
    • Re: SQL 2000 SP4 on 2003 Server - Single User Mode
      ... Do you know the name of the original database that your developer had setup? ... because I cannot enter single user mode ON any of the ... pre-installed databases that come with sql server 2000. ... SQL server integration behind it, ...
      (microsoft.public.sqlserver.setup)
    • Re: Limit FORM mailer submissions to 5 on website, then pause until reviewed by webmaster
      ... have a script that creates a temporary row in a sessions table as soon ... then don't display the input form and instead display the message, ... You wouldn't lock the file from the time they come to the page until ... the database occurs, ...
      (comp.lang.perl.misc)
    Loading