Jason-299789 (10/3/2012)

---

sql-noob (10/3/2012)

---

The user who is able to access the view belongs to a group which is added to the sql server from ADS(active directory services). Now the irony is...

Yes it does...

Yes it does contain the constraints which results in giving user specific results, my only concern is that it's applied only to the user who is logging through the application...

The user who is able to access the view belongs to a group which is added to the sql server from ADS(active directory services). Now the irony is other users...

before that i want to ask one thing,

Another user of appropriate privilages is able to access data from that view while the system administrator is not able to!

This means the...

No its not filtered, i also tried giving myself view level access on this particular view but that also didnt work out.

theres a view called as filtered product,

select * from dbo.filteredproduct

the result of this query gives around 25 outputs.

while the same query gives 0 output for system administrators.

Also the instance is...

thanks for the help! 🙂

i wrote the following procedure

if theres any correction please notify, i would be happy for your input on this

-------------------------------------------------------------------------------

/* creating a procedure*/

create/replace procedure <procedure_name>

as

decalre @sessid smallint

declare @idle_time_out = 30 --...

thanks for the help!

i am sure that will work, but sys.dm_exec_sessions is not their in sql server 2000 !

yes that can be done,

i am working on the issue from my end by using (sys.dm_exec_sessions) or should i use something else?

thanks for resolving my doubt!

Is there any other way instead of procedures to accomplish session time limiting in sql server 2000?

if it is sql server 2008, what's the way?

having a small doubt(silly one)

if i write a logon trigger(forget the sql version), is it like : after the completion of trigger the user gets the access or he gets...

a request from the client side, the problem is there are no logon triggers in sql server 2000, so is it feasible to write a procedure to check the session...