Auditors want us to track when Insert, Update and Delete failures occur. Is this possible in SQL 2000?
They also want us to track schema changes. Is this possible?
Thanks, DaveWhat constitutes a "failure" for the purpose of the audit?
-PatP|||The statement does not execute and returns an error. I believe I can trap this failures in Profiler, but I'm not sure what type of overhead this would create. Several people have suggested triggers, but I'm not sure a trigger will execute on failed attempts, only successfull insert, updates and deletes.
If I take the Profiler approach I'm not sure it will show schema changes.
Dave|||If you tell it to, SQL Profiler can track ANYTHING that goes to SQL Server. DML that works or fails, schema changes, and everything else. The question is: How much disk are you willing to dedicate to making this happen?
With the Profiler running "wide open" on a moderately busy server you are looking at 2-3 Tb of data in a 24 hour period... Once you've collected the data, you need to figure out what (if anything) you are going to do with it!
The old Chinese adage applies: Be careful what you wish for, you might get it!
-PatP|||We will only be monitoring two or three ids. Not sure if a domain group can be monitored, but if so we will monitor at the group level. This is for Sarbanes-Oxley complaince, which is basically very strict management of database systems for financial institutions. My thanks to Enron. Our DBAs are allowed to manage development and model office environments and a consulting company gets to manage production. Sarbanes-Oxley requires we keep an eye on the production DBAs by monitoring their activity. Profiler may not be the best approach. Even though we will be monitoring a small number of ids, SQL Server still needs to perform conditional logic against all user activity to see if the filter criteria is being met. A software tool may produce less overhead.
Thanks, Dave|||Everybody loves the joy of SOX!
If you really, really need to, you can get C2 (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_config_09yd.asp) auditing from SQL-2000. There are thousands of auditing combinations, many of which are pretty much designed for exactly what you want to do.
I'd be hard pressed to recommend a third party product for this use... At least in my opinion, it is likely to be more work than it is worth in the long run.
-PatP
Showing posts with label delete. Show all posts
Showing posts with label delete. Show all posts
Monday, March 19, 2012
Monday, March 12, 2012
Is it possible ?
Hi
I have users in domain group who use application which uses sqlserve, they
have rights to insert, update, delete. I want some of the members of this
domain group to connect directly to the database using query analyzer but
with right only to read and they still of course can use application and
have full rights.
I can't change application, i don't want to crate another users with
different rights.
I want the same user to have different rights using application and query
analyzer.
Is it possible ? Maybe something similar...
regards
m."marta" <marta20wawa@.go2.pl> wrote in message
news:dcbnmq$32b$1@.atlantis.news.tpi.pl...
> Hi
> I have users in domain group who use application which uses sqlserve, they
> have rights to insert, update, delete. I want some of the members of this
> domain group to connect directly to the database using query analyzer but
> with right only to read and they still of course can use application and
> have full rights.
> I can't change application, i don't want to crate another users with
> different rights.
> I want the same user to have different rights using application and query
> analyzer.
> Is it possible ? Maybe something similar...
>
Don't multi-post. See response in .server.
David|||If you are using user rights with an application and not an application
role, then there is no way for the server to differentiate between a
user using product x or product y; it simply sees a request for data
from a user.
However, if your application can be re-tooled to use an application
role instead, then that changes things drastically. Of course, that
limits your applications ability to inherit from Active Directory, so
it may not be a viable solution.
Stu
I have users in domain group who use application which uses sqlserve, they
have rights to insert, update, delete. I want some of the members of this
domain group to connect directly to the database using query analyzer but
with right only to read and they still of course can use application and
have full rights.
I can't change application, i don't want to crate another users with
different rights.
I want the same user to have different rights using application and query
analyzer.
Is it possible ? Maybe something similar...
regards
m."marta" <marta20wawa@.go2.pl> wrote in message
news:dcbnmq$32b$1@.atlantis.news.tpi.pl...
> Hi
> I have users in domain group who use application which uses sqlserve, they
> have rights to insert, update, delete. I want some of the members of this
> domain group to connect directly to the database using query analyzer but
> with right only to read and they still of course can use application and
> have full rights.
> I can't change application, i don't want to crate another users with
> different rights.
> I want the same user to have different rights using application and query
> analyzer.
> Is it possible ? Maybe something similar...
>
Don't multi-post. See response in .server.
David|||If you are using user rights with an application and not an application
role, then there is no way for the server to differentiate between a
user using product x or product y; it simply sees a request for data
from a user.
However, if your application can be re-tooled to use an application
role instead, then that changes things drastically. Of course, that
limits your applications ability to inherit from Active Directory, so
it may not be a viable solution.
Stu
Is it possible ...?
Hi
I have users in domain group who use application which uses sqlserve, they
have rights to insert, update, delete. I want some of the members of this
domain group to connect directly to the database using query analyzer but
with right only to read and they still of course can use application and
have full rights.
I can't change application, i don't want to crate another users with
different rights.
I want the same user to have different rights using application and query
analyzer.
Is it possible ? Maybe something similar...
regards
m.
"marta" <marta20wawa@.go2.pl> wrote in message
news:dcbnlj$2vi$1@.atlantis.news.tpi.pl...
> Hi
> I have users in domain group who use application which uses sqlserve, they
> have rights to insert, update, delete. I want some of the members of this
> domain group to connect directly to the database using query analyzer but
> with right only to read and they still of course can use application and
> have full rights.
> I can't change application, i don't want to crate another users with
> different rights.
> I want the same user to have different rights using application and query
> analyzer.
> Is it possible ? Maybe something similar...
>
In this situation users should be granted Read permissions only, and in the
application, they can acquire different permissions by running
sp_setapprole.
David
|||David Browne napisal(a):
> "marta" <marta20wawa@.go2.pl> wrote in message
> news:dcbnlj$2vi$1@.atlantis.news.tpi.pl...
> In this situation users should be granted Read permissions only, and in the
> application, they can acquire different permissions by running
> sp_setapprole.
> David
I can't change permissions asigned to domain group to which they
belong.
I can't change application in any way, i don't have acess to use
application role. I can't touch application. For me the best solution
would be if in query analyzer is check button "read only", and i could
use it ;)
I need to give users read only access using isql.
M.
|||I believe that the closest you can come is to create triggers on your tables from which you check
the application name (APP_NAME()) and if not expected, you rollback inside the trigger. This will
not prevent a bad seed from writing an app, setting the expected application name and do the bad
operations, though.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"sqlserver" <grupy_d@.go2.pl> wrote in message
news:1122622386.882273.249700@.g43g2000cwa.googlegr oups.com...
> David Browne napisal(a):
> I can't change permissions asigned to domain group to which they
> belong.
> I can't change application in any way, i don't have acess to use
> application role. I can't touch application. For me the best solution
> would be if in query analyzer is check button "read only", and i could
> use it ;)
> I need to give users read only access using isql.
> M.
>
|||Think of writing an app that lets users enter select SQL statements only and
shows the results in a grid control.
Don't set the grid to allow updates. You can probably find some code for
something like that in the samples.
HTH
"marta" <marta20wawa@.go2.pl> wrote in message
news:dcbnlj$2vi$1@.atlantis.news.tpi.pl...
> Hi
> I have users in domain group who use application which uses sqlserve, they
> have rights to insert, update, delete. I want some of the members of this
> domain group to connect directly to the database using query analyzer but
> with right only to read and they still of course can use application and
> have full rights.
> I can't change application, i don't want to crate another users with
> different rights.
> I want the same user to have different rights using application and query
> analyzer.
> Is it possible ? Maybe something similar...
> regards
> m.
>
I have users in domain group who use application which uses sqlserve, they
have rights to insert, update, delete. I want some of the members of this
domain group to connect directly to the database using query analyzer but
with right only to read and they still of course can use application and
have full rights.
I can't change application, i don't want to crate another users with
different rights.
I want the same user to have different rights using application and query
analyzer.
Is it possible ? Maybe something similar...
regards
m.
"marta" <marta20wawa@.go2.pl> wrote in message
news:dcbnlj$2vi$1@.atlantis.news.tpi.pl...
> Hi
> I have users in domain group who use application which uses sqlserve, they
> have rights to insert, update, delete. I want some of the members of this
> domain group to connect directly to the database using query analyzer but
> with right only to read and they still of course can use application and
> have full rights.
> I can't change application, i don't want to crate another users with
> different rights.
> I want the same user to have different rights using application and query
> analyzer.
> Is it possible ? Maybe something similar...
>
In this situation users should be granted Read permissions only, and in the
application, they can acquire different permissions by running
sp_setapprole.
David
|||David Browne napisal(a):
> "marta" <marta20wawa@.go2.pl> wrote in message
> news:dcbnlj$2vi$1@.atlantis.news.tpi.pl...
> In this situation users should be granted Read permissions only, and in the
> application, they can acquire different permissions by running
> sp_setapprole.
> David
I can't change permissions asigned to domain group to which they
belong.
I can't change application in any way, i don't have acess to use
application role. I can't touch application. For me the best solution
would be if in query analyzer is check button "read only", and i could
use it ;)
I need to give users read only access using isql.
M.
|||I believe that the closest you can come is to create triggers on your tables from which you check
the application name (APP_NAME()) and if not expected, you rollback inside the trigger. This will
not prevent a bad seed from writing an app, setting the expected application name and do the bad
operations, though.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"sqlserver" <grupy_d@.go2.pl> wrote in message
news:1122622386.882273.249700@.g43g2000cwa.googlegr oups.com...
> David Browne napisal(a):
> I can't change permissions asigned to domain group to which they
> belong.
> I can't change application in any way, i don't have acess to use
> application role. I can't touch application. For me the best solution
> would be if in query analyzer is check button "read only", and i could
> use it ;)
> I need to give users read only access using isql.
> M.
>
|||Think of writing an app that lets users enter select SQL statements only and
shows the results in a grid control.
Don't set the grid to allow updates. You can probably find some code for
something like that in the samples.
HTH
"marta" <marta20wawa@.go2.pl> wrote in message
news:dcbnlj$2vi$1@.atlantis.news.tpi.pl...
> Hi
> I have users in domain group who use application which uses sqlserve, they
> have rights to insert, update, delete. I want some of the members of this
> domain group to connect directly to the database using query analyzer but
> with right only to read and they still of course can use application and
> have full rights.
> I can't change application, i don't want to crate another users with
> different rights.
> I want the same user to have different rights using application and query
> analyzer.
> Is it possible ? Maybe something similar...
> regards
> m.
>
Is it possible ...?
Hi
I have users in domain group who use application which uses sqlserve, they
have rights to insert, update, delete. I want some of the members of this
domain group to connect directly to the database using query analyzer but
with right only to read and they still of course can use application and
have full rights.
I can't change application, i don't want to crate another users with
different rights.
I want the same user to have different rights using application and query
analyzer.
Is it possible ? Maybe something similar...
regards
m."marta" <marta20wawa@.go2.pl> wrote in message
news:dcbnlj$2vi$1@.atlantis.news.tpi.pl...
> Hi
> I have users in domain group who use application which uses sqlserve, they
> have rights to insert, update, delete. I want some of the members of this
> domain group to connect directly to the database using query analyzer but
> with right only to read and they still of course can use application and
> have full rights.
> I can't change application, i don't want to crate another users with
> different rights.
> I want the same user to have different rights using application and query
> analyzer.
> Is it possible ? Maybe something similar...
>
In this situation users should be granted Read permissions only, and in the
application, they can acquire different permissions by running
sp_setapprole.
David|||David Browne napisal(a):
> "marta" <marta20wawa@.go2.pl> wrote in message
> news:dcbnlj$2vi$1@.atlantis.news.tpi.pl...
> In this situation users should be granted Read permissions only, and in th
e
> application, they can acquire different permissions by running
> sp_setapprole.
> David
I can't change permissions asigned to domain group to which they
belong.
I can't change application in any way, i don't have acess to use
application role. I can't touch application. For me the best solution
would be if in query analyzer is check button "read only", and i could
use it ;)
I need to give users read only access using isql.
M.|||I believe that the closest you can come is to create triggers on your tables
from which you check
the application name (APP_NAME()) and if not expected, you rollback inside t
he trigger. This will
not prevent a bad seed from writing an app, setting the expected application
name and do the bad
operations, though.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"sqlserver" <grupy_d@.go2.pl> wrote in message
news:1122622386.882273.249700@.g43g2000cwa.googlegroups.com...
> David Browne napisal(a):
> I can't change permissions asigned to domain group to which they
> belong.
> I can't change application in any way, i don't have acess to use
> application role. I can't touch application. For me the best solution
> would be if in query analyzer is check button "read only", and i could
> use it ;)
> I need to give users read only access using isql.
> M.
>|||Think of writing an app that lets users enter select SQL statements only and
shows the results in a grid control.
Don't set the grid to allow updates. You can probably find some code for
something like that in the samples.
HTH
"marta" <marta20wawa@.go2.pl> wrote in message
news:dcbnlj$2vi$1@.atlantis.news.tpi.pl...
> Hi
> I have users in domain group who use application which uses sqlserve, they
> have rights to insert, update, delete. I want some of the members of this
> domain group to connect directly to the database using query analyzer but
> with right only to read and they still of course can use application and
> have full rights.
> I can't change application, i don't want to crate another users with
> different rights.
> I want the same user to have different rights using application and query
> analyzer.
> Is it possible ? Maybe something similar...
> regards
> m.
>
I have users in domain group who use application which uses sqlserve, they
have rights to insert, update, delete. I want some of the members of this
domain group to connect directly to the database using query analyzer but
with right only to read and they still of course can use application and
have full rights.
I can't change application, i don't want to crate another users with
different rights.
I want the same user to have different rights using application and query
analyzer.
Is it possible ? Maybe something similar...
regards
m."marta" <marta20wawa@.go2.pl> wrote in message
news:dcbnlj$2vi$1@.atlantis.news.tpi.pl...
> Hi
> I have users in domain group who use application which uses sqlserve, they
> have rights to insert, update, delete. I want some of the members of this
> domain group to connect directly to the database using query analyzer but
> with right only to read and they still of course can use application and
> have full rights.
> I can't change application, i don't want to crate another users with
> different rights.
> I want the same user to have different rights using application and query
> analyzer.
> Is it possible ? Maybe something similar...
>
In this situation users should be granted Read permissions only, and in the
application, they can acquire different permissions by running
sp_setapprole.
David|||David Browne napisal(a):
> "marta" <marta20wawa@.go2.pl> wrote in message
> news:dcbnlj$2vi$1@.atlantis.news.tpi.pl...
> In this situation users should be granted Read permissions only, and in th
e
> application, they can acquire different permissions by running
> sp_setapprole.
> David
I can't change permissions asigned to domain group to which they
belong.
I can't change application in any way, i don't have acess to use
application role. I can't touch application. For me the best solution
would be if in query analyzer is check button "read only", and i could
use it ;)
I need to give users read only access using isql.
M.|||I believe that the closest you can come is to create triggers on your tables
from which you check
the application name (APP_NAME()) and if not expected, you rollback inside t
he trigger. This will
not prevent a bad seed from writing an app, setting the expected application
name and do the bad
operations, though.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"sqlserver" <grupy_d@.go2.pl> wrote in message
news:1122622386.882273.249700@.g43g2000cwa.googlegroups.com...
> David Browne napisal(a):
> I can't change permissions asigned to domain group to which they
> belong.
> I can't change application in any way, i don't have acess to use
> application role. I can't touch application. For me the best solution
> would be if in query analyzer is check button "read only", and i could
> use it ;)
> I need to give users read only access using isql.
> M.
>|||Think of writing an app that lets users enter select SQL statements only and
shows the results in a grid control.
Don't set the grid to allow updates. You can probably find some code for
something like that in the samples.
HTH
"marta" <marta20wawa@.go2.pl> wrote in message
news:dcbnlj$2vi$1@.atlantis.news.tpi.pl...
> Hi
> I have users in domain group who use application which uses sqlserve, they
> have rights to insert, update, delete. I want some of the members of this
> domain group to connect directly to the database using query analyzer but
> with right only to read and they still of course can use application and
> have full rights.
> I can't change application, i don't want to crate another users with
> different rights.
> I want the same user to have different rights using application and query
> analyzer.
> Is it possible ? Maybe something similar...
> regards
> m.
>
Is it possible ...?
Hi
I have users in domain group who use application which uses sqlserve, they
have rights to insert, update, delete. I want some of the members of this
domain group to connect directly to the database using query analyzer but
with right only to read and they still of course can use application and
have full rights.
I can't change application, i don't want to crate another users with
different rights.
I want the same user to have different rights using application and query
analyzer.
Is it possible ? Maybe something similar...
regards
m."marta" <marta20wawa@.go2.pl> wrote in message
news:dcbnlj$2vi$1@.atlantis.news.tpi.pl...
> Hi
> I have users in domain group who use application which uses sqlserve, they
> have rights to insert, update, delete. I want some of the members of this
> domain group to connect directly to the database using query analyzer but
> with right only to read and they still of course can use application and
> have full rights.
> I can't change application, i don't want to crate another users with
> different rights.
> I want the same user to have different rights using application and query
> analyzer.
> Is it possible ? Maybe something similar...
>
In this situation users should be granted Read permissions only, and in the
application, they can acquire different permissions by running
sp_setapprole.
David|||David Browne napisal(a):
> "marta" <marta20wawa@.go2.pl> wrote in message
> news:dcbnlj$2vi$1@.atlantis.news.tpi.pl...
> > Hi
> >
> > I have users in domain group who use application which uses sqlserve, they
> > have rights to insert, update, delete. I want some of the members of this
> > domain group to connect directly to the database using query analyzer but
> > with right only to read and they still of course can use application and
> > have full rights.
> >
> > I can't change application, i don't want to crate another users with
> > different rights.
> >
> > I want the same user to have different rights using application and query
> > analyzer.
> > Is it possible ? Maybe something similar...
> >
> In this situation users should be granted Read permissions only, and in the
> application, they can acquire different permissions by running
> sp_setapprole.
> David
I can't change permissions asigned to domain group to which they
belong.
I can't change application in any way, i don't have acess to use
application role. I can't touch application. For me the best solution
would be if in query analyzer is check button "read only", and i could
use it ;)
I need to give users read only access using isql.
M.|||I believe that the closest you can come is to create triggers on your tables from which you check
the application name (APP_NAME()) and if not expected, you rollback inside the trigger. This will
not prevent a bad seed from writing an app, setting the expected application name and do the bad
operations, though.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"sqlserver" <grupy_d@.go2.pl> wrote in message
news:1122622386.882273.249700@.g43g2000cwa.googlegroups.com...
> David Browne napisal(a):
>> "marta" <marta20wawa@.go2.pl> wrote in message
>> news:dcbnlj$2vi$1@.atlantis.news.tpi.pl...
>> > Hi
>> >
>> > I have users in domain group who use application which uses sqlserve, they
>> > have rights to insert, update, delete. I want some of the members of this
>> > domain group to connect directly to the database using query analyzer but
>> > with right only to read and they still of course can use application and
>> > have full rights.
>> >
>> > I can't change application, i don't want to crate another users with
>> > different rights.
>> >
>> > I want the same user to have different rights using application and query
>> > analyzer.
>> > Is it possible ? Maybe something similar...
>> >
>> In this situation users should be granted Read permissions only, and in the
>> application, they can acquire different permissions by running
>> sp_setapprole.
>> David
> I can't change permissions asigned to domain group to which they
> belong.
> I can't change application in any way, i don't have acess to use
> application role. I can't touch application. For me the best solution
> would be if in query analyzer is check button "read only", and i could
> use it ;)
> I need to give users read only access using isql.
> M.
>|||Think of writing an app that lets users enter select SQL statements only and
shows the results in a grid control.
Don't set the grid to allow updates. You can probably find some code for
something like that in the samples.
HTH
"marta" <marta20wawa@.go2.pl> wrote in message
news:dcbnlj$2vi$1@.atlantis.news.tpi.pl...
> Hi
> I have users in domain group who use application which uses sqlserve, they
> have rights to insert, update, delete. I want some of the members of this
> domain group to connect directly to the database using query analyzer but
> with right only to read and they still of course can use application and
> have full rights.
> I can't change application, i don't want to crate another users with
> different rights.
> I want the same user to have different rights using application and query
> analyzer.
> Is it possible ? Maybe something similar...
> regards
> m.
>
I have users in domain group who use application which uses sqlserve, they
have rights to insert, update, delete. I want some of the members of this
domain group to connect directly to the database using query analyzer but
with right only to read and they still of course can use application and
have full rights.
I can't change application, i don't want to crate another users with
different rights.
I want the same user to have different rights using application and query
analyzer.
Is it possible ? Maybe something similar...
regards
m."marta" <marta20wawa@.go2.pl> wrote in message
news:dcbnlj$2vi$1@.atlantis.news.tpi.pl...
> Hi
> I have users in domain group who use application which uses sqlserve, they
> have rights to insert, update, delete. I want some of the members of this
> domain group to connect directly to the database using query analyzer but
> with right only to read and they still of course can use application and
> have full rights.
> I can't change application, i don't want to crate another users with
> different rights.
> I want the same user to have different rights using application and query
> analyzer.
> Is it possible ? Maybe something similar...
>
In this situation users should be granted Read permissions only, and in the
application, they can acquire different permissions by running
sp_setapprole.
David|||David Browne napisal(a):
> "marta" <marta20wawa@.go2.pl> wrote in message
> news:dcbnlj$2vi$1@.atlantis.news.tpi.pl...
> > Hi
> >
> > I have users in domain group who use application which uses sqlserve, they
> > have rights to insert, update, delete. I want some of the members of this
> > domain group to connect directly to the database using query analyzer but
> > with right only to read and they still of course can use application and
> > have full rights.
> >
> > I can't change application, i don't want to crate another users with
> > different rights.
> >
> > I want the same user to have different rights using application and query
> > analyzer.
> > Is it possible ? Maybe something similar...
> >
> In this situation users should be granted Read permissions only, and in the
> application, they can acquire different permissions by running
> sp_setapprole.
> David
I can't change permissions asigned to domain group to which they
belong.
I can't change application in any way, i don't have acess to use
application role. I can't touch application. For me the best solution
would be if in query analyzer is check button "read only", and i could
use it ;)
I need to give users read only access using isql.
M.|||I believe that the closest you can come is to create triggers on your tables from which you check
the application name (APP_NAME()) and if not expected, you rollback inside the trigger. This will
not prevent a bad seed from writing an app, setting the expected application name and do the bad
operations, though.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"sqlserver" <grupy_d@.go2.pl> wrote in message
news:1122622386.882273.249700@.g43g2000cwa.googlegroups.com...
> David Browne napisal(a):
>> "marta" <marta20wawa@.go2.pl> wrote in message
>> news:dcbnlj$2vi$1@.atlantis.news.tpi.pl...
>> > Hi
>> >
>> > I have users in domain group who use application which uses sqlserve, they
>> > have rights to insert, update, delete. I want some of the members of this
>> > domain group to connect directly to the database using query analyzer but
>> > with right only to read and they still of course can use application and
>> > have full rights.
>> >
>> > I can't change application, i don't want to crate another users with
>> > different rights.
>> >
>> > I want the same user to have different rights using application and query
>> > analyzer.
>> > Is it possible ? Maybe something similar...
>> >
>> In this situation users should be granted Read permissions only, and in the
>> application, they can acquire different permissions by running
>> sp_setapprole.
>> David
> I can't change permissions asigned to domain group to which they
> belong.
> I can't change application in any way, i don't have acess to use
> application role. I can't touch application. For me the best solution
> would be if in query analyzer is check button "read only", and i could
> use it ;)
> I need to give users read only access using isql.
> M.
>|||Think of writing an app that lets users enter select SQL statements only and
shows the results in a grid control.
Don't set the grid to allow updates. You can probably find some code for
something like that in the samples.
HTH
"marta" <marta20wawa@.go2.pl> wrote in message
news:dcbnlj$2vi$1@.atlantis.news.tpi.pl...
> Hi
> I have users in domain group who use application which uses sqlserve, they
> have rights to insert, update, delete. I want some of the members of this
> domain group to connect directly to the database using query analyzer but
> with right only to read and they still of course can use application and
> have full rights.
> I can't change application, i don't want to crate another users with
> different rights.
> I want the same user to have different rights using application and query
> analyzer.
> Is it possible ? Maybe something similar...
> regards
> m.
>
Is it ok?
Here is what's happening to my database -
I have a table that shows about 40 dependencies in
via EM. Thereafter, when I add and delete certain columns
in the table, it shows about 8 dependencies. Even though
the columns I am adding/deleting don't have any reference
in dependencies.
In this instance is it ok to use the application or its
a matter of concern. How do I resolve this?
Thank you,
-Linda
Are these dependencies other tables? Perhaps the referential integrity
constraints were defined that way?
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
I have a table that shows about 40 dependencies in
via EM. Thereafter, when I add and delete certain columns
in the table, it shows about 8 dependencies. Even though
the columns I am adding/deleting don't have any reference
in dependencies.
In this instance is it ok to use the application or its
a matter of concern. How do I resolve this?
Thank you,
-Linda
Are these dependencies other tables? Perhaps the referential integrity
constraints were defined that way?
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
Is it ok?
Here is what's happening to my database -
I have a table that shows about 40 dependencies in
via EM. Thereafter, when I add and delete certain columns
in the table, it shows about 8 dependencies. Even though
the columns I am adding/deleting don't have any reference
in dependencies.
In this instance is it ok to use the application or its
a matter of concern. How do I resolve this?
Thank you,
-LindaAre these dependencies other tables? Perhaps the referential integrity
constraints were defined that way?
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
I have a table that shows about 40 dependencies in
via EM. Thereafter, when I add and delete certain columns
in the table, it shows about 8 dependencies. Even though
the columns I am adding/deleting don't have any reference
in dependencies.
In this instance is it ok to use the application or its
a matter of concern. How do I resolve this?
Thank you,
-LindaAre these dependencies other tables? Perhaps the referential integrity
constraints were defined that way?
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
Is it ok?
Here is what's happening to my database -
I have a table that shows about 40 dependencies in
via EM. Thereafter, when I add and delete certain columns
in the table, it shows about 8 dependencies. Even though
the columns I am adding/deleting don't have any reference
in dependencies.
In this instance is it ok to use the application or its
a matter of concern. How do I resolve this?
Thank you,
-LindaAre these dependencies other tables? Perhaps the referential integrity
constraints were defined that way?
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
I have a table that shows about 40 dependencies in
via EM. Thereafter, when I add and delete certain columns
in the table, it shows about 8 dependencies. Even though
the columns I am adding/deleting don't have any reference
in dependencies.
In this instance is it ok to use the application or its
a matter of concern. How do I resolve this?
Thank you,
-LindaAre these dependencies other tables? Perhaps the referential integrity
constraints were defined that way?
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
Friday, March 9, 2012
Is it best way put all the validation rules on insert/update/delete stored procedure?
Is it best way put all the validation rules on insert/update/delete stored
procedure?
When the failure happen from the validation rules, it will return all errors
to client.Hi
http://www.sommarskog.se/error-handling-I.html
http://www.sommarskog.se/error-handling-II.html
"ABC" <abc@.abc.com> wrote in message
news:%23D9HmCM8FHA.3044@.TK2MSFTNGP10.phx.gbl...
> Is it best way put all the validation rules on insert/update/delete stored
> procedure?
> When the failure happen from the validation rules, it will return all
> errors to client.
>
procedure?
When the failure happen from the validation rules, it will return all errors
to client.Hi
http://www.sommarskog.se/error-handling-I.html
http://www.sommarskog.se/error-handling-II.html
"ABC" <abc@.abc.com> wrote in message
news:%23D9HmCM8FHA.3044@.TK2MSFTNGP10.phx.gbl...
> Is it best way put all the validation rules on insert/update/delete stored
> procedure?
> When the failure happen from the validation rules, it will return all
> errors to client.
>
Subscribe to:
Posts (Atom)