Hi,
I work as an IT Administrator and part of my job role is to use
Enterprise Manager and Query Analyzer to backup the logins and
permissions for each database on our SQL Servers. This information is
used as a backup in the event of a server failing so we then have
something to fall back on if we need to add the same logins/permissions
again.
This takes ages to do, as I have to manually enter all the information
into a spreadsheet.
Steps:
- In Enterprise Manager I connect to a server then 'Security' tab, then
'Logins'. I then enter all items into a spreadsheet.
- In Query Analyzer I connect to a server then do 'sp_helpuser' to list
all the permissions for each database. I then enter all information
into a spreadsheet.
I was wondering if there is such a program available on the market that
would do this for me? I know that MS Baseline Security can show flat
file share permissions to a certain degree and was wondering if there
was a similar program out there to help me do my job easier, or if
there is a simple way of doing this in the future...
Any feedback would be greatly appreciated.
Regards,
Jenny
2  1994 
Run SQL profiler and capture the SQL enterprise manager is throwing at the
server and then you can customise this and get DTS to output your
spreadsheet for you.
--
Tony Rogerson
SQL Server MVP http://sqlblogcasts.com/blogs/tonyrogerson - technical commentary from a SQL
Server Consultant http://sqlserverfaq.com - free video tutorials
<ha**********@h otmail.com> wrote in message
news:11******** **************@ h76g2000cwa.goo glegroups.com.. . Hi,
I work as an IT Administrator and part of my job role is to use
Enterprise Manager and Query Analyzer to backup the logins and
permissions for each database on our SQL Servers. This information is
used as a backup in the event of a server failing so we then have
something to fall back on if we need to add the same logins/permissions
again.
This takes ages to do, as I have to manually enter all the information
into a spreadsheet.
Steps:
- In Enterprise Manager I connect to a server then 'Security' tab, then
'Logins'. I then enter all items into a spreadsheet.
- In Query Analyzer I connect to a server then do 'sp_helpuser' to list
all the permissions for each database. I then enter all information
into a spreadsheet.
I was wondering if there is such a program available on the market that
would do this for me? I know that MS Baseline Security can show flat
file share permissions to a certain degree and was wondering if there
was a similar program out there to help me do my job easier, or if
there is a simple way of doing this in the future...
Any feedback would be greatly appreciated.
Regards,
Jenny This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Ike |
last post by:
I am running off of a MySQL database on a remote server. I am truly
concerned about backup. I have phpMyAdmin running on the remote server, and
I see I can "Export" to various formatsd from there, but nothing to "Import
if I need to reinstate my data.
How do you typically backup a MySQL database? Cant I simply copy the files?
How does one do this if I want, say, to backup the files from the remote
server, to my local harddrive? Thanks,...
|
by: Dave |
last post by:
I am doing a complete backup on a sql 7 db and then doing a complete
restore (with overwrite existing db) on a sql 2000 server. This is now
our hot standby server. I have the process automated and it works
great. The only problem I have now is the logins dont work.
I have tried running EXEC sp_change_users_login 'Report', and the
logins appear.
However, when I run EXEC sp_helplogins 'joe', the results are empty.
So, I am guessing all...
|
by: Ryan |
last post by:
We have a DTS package developed on our development PC's (SQL 7). It
runs fine. When we schedule it on the server (SQL 7), it fails. We
have been able to find that this is a known issue down to the use of
permissions (running it uses the users permissions, scheduling it uses
the servers). http://support.microsoft.com/?kbid=269074
Our Ops Support team insist that we have the full permissions to run
this, but it still fails. If we log on to...
|
by: David McGeorge |
last post by:
I am confused about windows account, win dimain account, sql login
accoun and sql database user account.... can you give me a fresh
example to show the exact relationship between them and how they work
together?
|
by: Lyle Fairfield |
last post by:
I have a tiny db on a remote sql server. The owner of the sever backs up the
db daily, but these backups are not freely available to me. I want my data
(only my data) backed up in some form that is accessible to me.
I have an adp. It exists only to connect to the remote db.
I have an mdb. It has a form. The form opens on the db’s opening. This is the
code behind the form. It zaps any tables in the mdb. It examines the tables
in the adp....
| | |
by: bjorn.augestad |
last post by:
Hi, all.
We have a couple of pathological sql servers that have lots and lots of
page faults per second, up to 4000. Our client programs are written in
C#/.NET 1.1 and utilizes connection pooling.
Some of the client programs seems to log in hundred of times per
second, as reported by perfmon->.SQLServer:General
Statistics->Logins/sec. Stopping the client programs reduces that
number significantly.
|
by: Inna |
last post by:
Hello all,
I am looking for the script, which I believe exists already.I need to
be able to populate the script for security of one database and
apply it to another database, even if it is located on another server:
1. All logins which not exist have to be created and which exists
ignored including the NT accounts
2. Users same as the old database + the existing ones stay in database
3. Passwords for the new logins.
4. All...
|
by: Simon Watkins |
last post by:
Our server administrators recently changed the permissions of most of our
servers (you know how it is, the developers had, shock horror, got to know
the domain administrator password, and some decision was made on high to
clamp down on everything)
This consequently has had the effect of rendering our live ASP.NET 2 web
server useless with page requests for .NET sites returning ACL permission
errors.
I ran a few tools and found out...
|
by: SysProg |
last post by:
I need some help with a problem I've encountered. I am a zLinux, WAS, and DB2 noob so please bear with me.
I am helping to support two WebSphere applications which utilize DB2 under zLinux. One application is for Europe and the other for the US. Each application has multiple WAS servers and HTTP servers backed by their own DB2 server. A script is run for each application that exports data from a z/OS-based DB2 database into a file on the...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| | |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
