Shashank, Please be aware that this newsgroup is dedicated to support of the following SoftTree Technologies software products: 1. DB Tools for Oracle 2. DB Audit for Oracle, SQL Server, Sybase, and DB2 3. DB Mail for Oracle, SQL Server, Sybase, and DB2 This newsgroup is maintained and paid for by SoftTree Technologies and we do not provide free support for third-party tools and otherwise non-product related issues. Please post your "general" questions in free forums offered by Google, Yahoo and other web sites. : Hello friends, : we have sql server2000 , when we go to console root>SQL SERVER : GROUP>DATABASE>MANAGEMENT>CURRENT ACTIVITY : ....In Management option we have Current Activity/Lock Process Id..... : ....Here we found in object for perticularId, owner of table is different. : for example : tablename.xyz.view_02 like that : where tablename is name of table , 'xyz' is admin user, view_02 is some view : OR TABLE on which admin user/ANT USER fired query. but in right side of : current activity we have some columns like : object,locktype,mode,status,owner,index,resource like that and in that we : saw owner of table is different than 'xyz'. : why is each table name preceding with user name, where as owner of these : tables is different.(in right side of tree view for object column , we : saw) : is that thing is related to authentications? means user has right, so his : name should follow then name of table , like that....???? : so my question is that will that possible, if yes then how that shown : different : if that was not possible then why it is showing such things : Please help me out!!!! : thanks : shashank
|