Database security

From: Tanuj Ralhan (tanujralhan_at_yahoo.com)
Date: 10/27/03

  • Next message: Allan Mitchell: "Re: Database security" 
    Date: Mon, 27 Oct 2003 01:52:57 -0800

    Hi everybody

    I have a VB6 application, which connects to a SQL Server.
    I want my user to connect to the database using a single
    user/password as the data security is implemented thru the
    application itself. Please help me as to how I create such
    user (not sa) and grant full permission to the database.
    Also in case of full system restore how the database would
    be recreated with the same permission and would the users
    have to logon as "sa" to do that.
    Thanks in advance.

  • Next message: Allan Mitchell: "Re: Database security"

    Relevant Pages

    • Re: low permission cannot convert from A97 to A2000/2003
      ... Delete is a separate permission. ... You need open exclusive permission on the database to ... > The admin user has full privileges. ... > as we wont be importing those files from them, and the contractor will be ...
      (microsoft.public.access.security)
    • Re: low permission cannot convert from A97 to A2000/2003
      ... Delete is a separate permission. ... You need open exclusive permission on the database to ... > The admin user has full privileges. ... > as we wont be importing those files from them, and the contractor will be ...
      (microsoft.public.access.conversion)
    • Could not Lock File error
      ... >I'm trying to share an access database with an entire ... >modifying this file with FULL PERMISSION on the parent ... >or not AND ONLY allowing one person to modify it's ... It's called an .LDB file, ...
      (microsoft.public.access.security)
    • Re: Help with very repetitive task in excel...is there an answer?
      ... > It's easier to beg forgiveness than ask permission :-) ... >> I've got a csv database of text to upload to my website database. ... >> A) is at the end of this html code. ...
      (microsoft.public.excel.programming)
    • Re: dumb++ security
      ... If the user doesn't have permission ... > to connect to either database, ... Proud Member of the Exclusive "I have been plonked by Davee because he ... > database/some server to perform task A. ...
      (comp.security.misc)