Re: store procedure security
From: Fernando G. Guerrero (fernan@guerrerog.org)
Date: 09/16/02
- Next message: Donal Devine: "Re: Read Only SQL Login and Crystal Reports"
- Previous message: Dmitriy Shilonosov: "Application Role"
- In reply to: omar shafik: "store procedure security"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Fernando G. Guerrero" <fernan@guerrerog.org> Date: Mon, 16 Sep 2002 03:04:43 -0400
If your concern is about programmers overwriting other programmers objects,
you should consider using a Source Code Control System., such as Visual
Source Safe, or any other commercial system like it. In this case you would
have full control on who did what and when, giving you the possibility of
restoring any old version of the script when necessary.
It is a shame that Visual Source Safe doesn't integrate natively with SQL
Server, but you can use Visual Interdev to achieve this integration, or do
it, or use Visual Studio .NET which can integrate Visual Source Safe 6.0c to
control source code of SQL Server objects interactively. In this case you
can control permissions on source code for each user individually.
-- Fernando G. Guerrero SQL Server MVP QA plc., UK PASS Spanish Group www.sqlserverbyexample.com www.callsql.com www.qa.com "Share what you know, learn what you don't" "omar shafik" <omar.shafik@microtech.com.eg> wrote in message news:OfEXMKLXCHA.2744@tkmsftngp10... > Hi all, > I want to have some security on the stored procedures, triggers, and views. > multiple programmers are updating the same stored procedure. so is there > any tool that works with sql for security and keep records. > Thank you, > OMS > >
- Next message: Donal Devine: "Re: Read Only SQL Login and Crystal Reports"
- Previous message: Dmitriy Shilonosov: "Application Role"
- In reply to: omar shafik: "store procedure security"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
