SQL Users AUDIT stored procedure 2 |
02/26/2008 |
|
Category:
Development Tools / Databases
|
|
Description of SQL Users AUDIT stored procedure
Stored procedure compatible with Microsoft SQL Server 2005 that shows detailed information about database users. The information can be obtained for a specific database or for all databases on your server. The output contains a list of all users from the database(s) with their logins, the roles to witch are assigned, owned schemas, etc. A very useful tool when you try to keep track of all your database's users or when you want to refresh a database and restore afterwards its original users.
Features :
You may choose to view user information from all databases or from a specific database.
If you want to refresh a database, a list with all its users can be backup and used afterwards to restore the original settings.
Easy to monitor database changes using backup lists taken peridically.
List of database roles and user defined roles.
Easy to see if there are orphaned users in your databases.
Informations about users schema and objects.
Easy integration and Full source code
|
| Comments |
| No comments have been submitted for this product. Be the first user to submit a comment. |
|
| More Similar Software |
 |
EZStoredProc 2.0.0
... Don't you wish that there is a tool out there that will magically generate the Insert, Select, Update, and Delete stored procedure scripts for you by simply right-clicking on a database or table?
Look no further! EZStoredProc (pronounced as "Easy Stored Proc") is that magical tool. Unlike the clumsy wizard provided by MS SQL Server Enterprise Manager, EZStoredProc does not add a number to the end of every parameter of the generated stored procedure. It is a lot smarter in handling primary key, ...
|
| |
Lattice.SPGen Stored Procedure and Code Generator 3.0
... Lattice.SPGen is a template-based stored procedure and code
generator that supports Microsoft SQL Server, Oracle, IBM DB2 UDB, PostgreSQL
and MySQL. It processes any tables and views in the database that you select
and generate stored procedures scripts of insert, update, delete, select (single
or multiple records) as well as business entities for C# and VB.NET. The output
scripts file can be chosen as one file for all tables / views or one per table /
view based on your ...
|
| |
Extended Stored Procedure component 1
... MS SQL Server 7.0/2000 Extended Stored Procedure component for Delphi 5,6,7.
Write Extended Stored Procedures for Microsoft SQL Server with ease:
* Control over input/output procedure parameters.
* Return an arbitrary number of recordsets.
* Parameters and Fields can be accessed by using the familiar properties: AsInteger, AsDateTime, AsCurrency, etc.
* Real world code: it works as a part of the complex accounting system, 7 days a week, 24 hours a day. ...
|
| |
DecryptSQL 2.8.0
... Do you have such kind experience that you can not view the complete SQL Script because of the reason with "WITH ENCRYPTION" when you view the Stored Procedure, View, Trigger and Function of SQL SERVER 2000? If yes, the DecrypSQL can help you to view the complete SQL Script quickly and exactly. It is suitable to use for programmer & DBA.
Now feel the convenience of DecryptSQL!
Key Features of DecryptSQL:
- Work in Microsoft SQL Server 2000 and Microsoft Database Engine (MSDE).
- ...
|
| |
Kickstart 1.02
... Kickstart is a powerful tool for DBAs and software developers. It lets you write scripts using a simple Basic like language to generate database objects for every table in a Database schema. For example, you might have developed a robust Oracle stored procedure that inserts rows into a particular database as well as handling security, audit trails and locking. If you want to use that stored procedure as a standard template then you can do it manually, cutting, pasting, editing and testing or you ...
|
|
|
| |
| Submit Rating |
|
| Editor Rating = 5 |
 |
|
|
| Author: |
sqlscripts2000 |
| License: |
Shareware |
| Price: |
$32 |
| File Size: |
3.5 KB |
| Downloads: |
10 |
|
|
|
|
|
| |
| |
| Popular Software |
| |
MySQL v5.0.27
... MySQL is a very fast, multi-threaded, multi-user and robust SQL (Structured Query Language) database ...
|
| |
MySQL-Front v3.2
... MySQL-Front is a easy to use, compact and very fast graphical tool to manage your MySQL database ...
|
| |
Visual SQL-Designer v4.01
... Visual SQL-Designer is a program for easy visual constructing hard SQL-query for any database and ...
|
| |
EMS MySQL Manager Lite v4.0
... EMS MySQL Manager Lite is an excellent freeware graphical tool for MySQL Server administration. ...
|
| |
Crack Killer v1.20
... Crack Killer is a database application that lets software authors track and report web sites hosting ...
|
| |
EMS PostgreSQL Manager Lite v3.8
... EMS PostgreSQL Manager Lite is a light and easy-to-use freeware graphical tool for PostgreSQL ...
|
| |
Toad for MySQL v2.0.3
... Toad for MySQL empowers MySQL developers and administrators develop code more efficiently. It also ...
|
| |
NuSphere MySQL v1.14.1
... NuSphere MySQL is an integrated, multi-platform distribution of the most popular open source ...
|
| |
EMS IB/FB Manager Professional v4.4
... EMS IB/FB Manager is a high-performance tool for administering InterBase and FireBird. Its Graphical ...
|
| |
EMS MS SQL Manager Lite v2.6
... EMS MS SQL Manager Lite is a light and easy-to-use freeware graphical tool for MS SQL/MSDE ...
|
|
|
Submit Software