I know that there are tools like Lumigent, but an wondering about the
internal facilities to track events such as table creation, security
operations (add login, add role), and such.
Under Sybase, there is a set of procedures that permit you to set
theses events and to record the results for later extraction and
analysis.
The Profiler seems to have a lot of the same functionality but this
appears to be more along the lines of running a monitor.
Can the events be tracked without Profiler running?
Can the events being tracked be recorded in the system of SQLServer
logs? 4 1361
byrocat (bd******@sympa tico.ca) writes: I know that there are tools like Lumigent, but an wondering about the internal facilities to track events such as table creation, security operations (add login, add role), and such.
Under Sybase, there is a set of procedures that permit you to set theses events and to record the results for later extraction and analysis.
The Profiler seems to have a lot of the same functionality but this appears to be more along the lines of running a monitor.
Can the events be tracked without Profiler running?
Yes. But I am not going to say that it is particular appealing.
The good news is that in SQL Server 2005, currently in beta, you can
define triggers on database and server level, which makes this sort of
auditing a lot more reasonable to do.
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se
Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinf...2000/books.asp
Erland, would you haoppen to have an URL to a Technote or soemthing
similar that lays out the procedures for setting auditing of events
other than logins?
byrocat (bd******@sympa tico.ca) writes: Erland, would you haoppen to have an URL to a Technote or soemthing similar that lays out the procedures for setting auditing of events other than logins?
You mean with Profiler? No, I don't have any reference any such texts.
You can look up C2 auditing in Books Online, but you will not find much.
There is a reference to a "C2 Administrator's and User's Security Guide",
but there is no link.
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se
Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinf...2000/books.asp
"byrocat" <bd******@sympa tico.ca> wrote in message
news:11******** **************@ o13g2000cwo.goo glegroups.com.. . Erland, would you haoppen to have an URL to a Technote or soemthing similar that lays out the procedures for setting auditing of events other than logins?
See sp_trace_create (and related procs) in Books Online. I agree with Erland
that it's not always perfect, but you can trace anything that Profiler can
trace, which obviously extends beyond just login events.
Simon This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Martijn Rutte |
last post by:
Hi,
On one side, I have a Sybase 12.5 32 bits Server running on AIX 5.1
(maintenance level 3). On the other, I've got W2000 5.00.2195 (SP2)
with SQL Server Standard Edition, Product Version 8.00.534 (SP2),
having installed MDAC 2.6.
I connect to the Sybase 12.5 database using Merant ASE ODBC driver for
Sybase 12.5, and using the Microsoft OLE DB Provider for SQL Server
that comes with this SQLServer version.
|
by: Jim Douglas |
last post by:
Do they play well together? Anyone using the Sybase .NET provider. Any
problems or should I stick with
the Sybase OLEDB? Or worse check with the DataDirect folks for their .NET
provider for Sybase?
If you are using Sybase what are you using? We have issues with the Sybase
12.5 OleDBProvider and Sybase says is "not certified" for .NET. The provider
they have for .NET seems to have some performance issues?
|
by: sleepite |
last post by:
If I configure PHP with:
../configure --with-mysql --with-apxs2=/www/bin/apxs --with-sybase-ct=/usr/lo
cal/freetds --enable-track-vars --with-xml --with-zlib-dir=/rpms/zlib-1.2.3
--with-png --with-jpeg-dir=/rpms/jpeg-6b --with-freetype-dir=/rpms/freetype-
2.1.10 --with-gd=/usr/local --enable-gd-native-ttf
GD works perfectly with freetype support and everything but I get:
Warning: sybase_connect() : Sybase: Unable to
|
by: Patrick |
last post by:
I have an ASP.NET application that connects to a SQL Server database.
The SQL Server resides on a seperate development server from the IIS5.1 on
Windows XP SP2 on development PCs which host the ASP.NET application.
I would like to use Integrated Windows Authentication like
Integrated Security=SSPI;Persist Security Info=False;Initial
Catalog=DBName;Data Source=DevServer1
My problems!
|
by: kirpi |
last post by:
There is an SQLServer database somewhere, and I would like to grab and
publish some data to my web pages.
I was told: "please, do", and given server address, database name, id,
and password.
My site is hosted on Linux at aruba.it and I do not have root rights,
nor any chance to edit whatever server setup. All I can do is use the
available tools, which you cand find here http://62.149.140.28/ver.php
All I need is query for a few data...
| |
by: Simone |
last post by:
Hi,
I have to convert an MySQL database into a ms-sqlserver database.
Anyone know a software (is is possible freeware or not so expensive) to
translate database?
I have only to translate tables, no triggers or stored procedures.
Or anyone can send me a link to a web site about this problem?
Tank you and escuse for my terrible english!
Simone (form Italy)
|
by: Alex Murphy |
last post by:
As title, Thanks
|
by: abdulbasith |
last post by:
hi
i need to select a data from a sybase table into a sql server 2005 table.i dont know whts is the query to do it, let me show u my code.i get error when i do that query
select * from openrowset('MSDASQL','dsn=bodaily;uid=sa;pwd=welcome;Initial Catalog=phoenix;',
' select rim from rm_acct')
this rm_acct is a sybase table
can anyone guide me on this.
thanks
|
by: ammoos |
last post by:
Hi Friends
How to join two tables, one is from sql sever and other is from sybase
Please help me
Thanks
|
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: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
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: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |