Unix Technical Forum

obtaining authority to run list applications - ordinary users

This is a discussion on obtaining authority to run list applications - ordinary users within the DB2 forums, part of the Database Server Software category; --> Hi, Some of my users would like to use the 'list applications' command to view processes being run. But ...


Go Back   Unix Technical Forum > Database Server Software > DB2

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-27-2008, 03:12 AM
Peter Sands
 
Posts: n/a
Default obtaining authority to run list applications - ordinary users

Hi,
Some of my users would like to use the 'list applications' command to
view processes being run. But I do not want them to belong to the
SYSMAINT group or any other system group( DBADM/SYSCTRL/SYSADM). As
far as I know this is the only way one can use that command. Is there
any other way where I can give them authority/permissions that just
allows them to run the that command without having other system type
authority.

aix 5.2
db2 8.1. 4

thanks
Peter
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 02-27-2008, 03:12 AM
Ian
 
Posts: n/a
Default Re: obtaining authority to run list applications - ordinary users

Peter Sands wrote:
> Hi,
> Some of my users would like to use the 'list applications' command to
> view processes being run. But I do not want them to belong to the
> SYSMAINT group or any other system group( DBADM/SYSCTRL/SYSADM). As
> far as I know this is the only way one can use that command. Is there
> any other way where I can give them authority/permissions that just
> allows them to run the that command without having other system type
> authority.


I have used the freeware 'sudo' tool to allow users to execute specific
commands (like list applications) with increased authority, this works
quite well.



----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= East/West-Coast Server Farms - Total Privacy via Encryption =---
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 02-27-2008, 03:12 AM
Sean McKeough
 
Posts: n/a
Default Re: obtaining authority to run list applications - ordinary users

There's a new group SYSMON_GROUP...not sure if it's on your fixpack level.

Peter Sands wrote:
> Hi,
> Some of my users would like to use the 'list applications' command to
> view processes being run. But I do not want them to belong to the
> SYSMAINT group or any other system group( DBADM/SYSCTRL/SYSADM). As
> far as I know this is the only way one can use that command. Is there
> any other way where I can give them authority/permissions that just
> allows them to run the that command without having other system type
> authority.
>
> aix 5.2
> db2 8.1. 4
>
> thanks
> Peter

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old 02-27-2008, 03:12 AM
Private Pyle
 
Posts: n/a
Default Re: obtaining authority to run list applications - ordinary users

peter_sands@techemail.com (Peter Sands) wrote in message news:<6b009995.0411080847.1931ad72@posting.google. com>...
> Hi,
> Some of my users would like to use the 'list applications' command to
> view processes being run. But I do not want them to belong to the
> SYSMAINT group or any other system group( DBADM/SYSCTRL/SYSADM). As
> far as I know this is the only way one can use that command. Is there
> any other way where I can give them authority/permissions that just
> allows them to run the that command without having other system type
> authority.
>
> aix 5.2
> db2 8.1. 4
>
> thanks
> Peter


You could write a shell script that the could execute that would run
the command. Set the permissions to 711 so they could run it, but
not read the file. Just attach to the instance as the instance owner
and list applications in the script.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 07:42 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com