SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
How it is showing name of owner different than

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
How it is showing name of owner different than
Author Message
shashank



Joined: 26 May 2005
Posts: 4

Post How it is showing name of owner different than act Reply with quote

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

Thu Jun 02, 2005 12:26 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7842

Post Re: How it is showing name of owner different than Reply with quote

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

Thu Jun 02, 2005 12:50 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.