Results 1 to 4 of 4
  1. #1
    RayMilhon is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    Aug 2011
    Location
    Southern California
    Posts
    1,067

    SQL Server Security Issue


    We have a SQL Server Database in our local shop. There are 5 Databases in this SQL Server Instance. 3 were designed and built here for our use. The other 2 are commercial Databases bought by our Corporate Headquarters. The Production Databases are housed at corporate. We have a copy here for reporting purposes. The copy is backed up once a week to a portable Hard Drive transported to our office and restored to our Server. The problem is that Every week the permissions for those 2 databases are blasted and have to be recreated every week. Doesn't take that long but I was wondering if this was something we could create in a stored Procedure in the Master database and then run after the backup is restored. If so, where can I find the syntax for this in SQL Server books online? I've looked and either it's not in there or I'm not looking in the right place.

    Thanks for any help you can give.

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    RayMilhon is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    Aug 2011
    Location
    Southern California
    Posts
    1,067
    Thanks Paul. I had read that earlier but wasn't clear on how to incorporate it for my purposes. After re-reading it from your link it dawned on me I could put it into a stored procedure and run that each week when the data is transferred. Thanks again

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    No problem!
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Security with SQL Server 2005
    By Datech in forum SQL Server
    Replies: 2
    Last Post: 07-08-2012, 03:57 PM
  2. Access security ODBC to SQL Server
    By Mark@CHP in forum Security
    Replies: 3
    Last Post: 03-27-2012, 08:31 AM
  3. access on server security
    By bigmac in forum Security
    Replies: 1
    Last Post: 03-11-2012, 06:02 AM
  4. Replies: 1
    Last Post: 01-29-2011, 10:52 PM
  5. Unable to enter data - security issue?
    By Huddle in forum Forms
    Replies: 2
    Last Post: 09-13-2010, 08:51 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums