473,395 Members | 1,745 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,395 software developers and data experts.

db2 authorities very vague

Hi,

The way authorities are granted in DB2 are very vague.In one of our
production systems the users under staff group in AIX have sysmon
authorities and i have checked dbm cfg and there sysmon_group is empty.
So how every member of staff have sysmon authority.why so?

How can a user run "db2 list applications" and db2 "get snapshot ....."
with these authorities?
db2 get authorizations

Administrative Authorizations for Current User

Direct SYSADM authority = NO
Direct SYSCTRL authority = NO
Direct SYSMAINT authority = NO
Direct DBADM authority = NO
Direct CREATETAB authority = NO
Direct BINDADD authority = NO
Direct CONNECT authority = YES
Direct CREATE_NOT_FENC authority = NO
Direct IMPLICIT_SCHEMA authority = NO
Direct LOAD authority = NO
Direct QUIESCE_CONNECT authority = NO
Direct CREATE_EXTERNAL_ROUTINE authority = NO
Direct SYSMON authority = NO

Indirect SYSADM authority = NO
Indirect SYSCTRL authority = NO
Indirect SYSMAINT authority = NO
Indirect DBADM authority = NO
Indirect CREATETAB authority = NO
Indirect BINDADD authority = NO
Indirect CONNECT authority = NO
Indirect CREATE_NOT_FENC authority = NO
Indirect IMPLICIT_SCHEMA authority = NO
Indirect LOAD authority = NO
Indirect QUIESCE_CONNECT authority = NO
Indirect CREATE_EXTERNAL_ROUTINE authority = NO
Indirect SYSMON authority = NO

Jul 12 '06 #1
3 2781
Ian
Dibur wrote:
Hi,

The way authorities are granted in DB2 are very vague.In one of our
production systems the users under staff group in AIX have sysmon
authorities and i have checked dbm cfg and there sysmon_group is empty.
So how every member of staff have sysmon authority.why so?

How can a user run "db2 list applications" and db2 "get snapshot ....."
with these authorities?
Is SYSADM_GROUP set to STAFF?

Is the DB2_SNAPSHOT_NOAUTH registry variable set?

Jul 12 '06 #2
Dibur wrote:
Hi,

The way authorities are granted in DB2 are very vague.In one of our
production systems the users under staff group in AIX have sysmon
authorities and i have checked dbm cfg and there sysmon_group is empty.
So how every member of staff have sysmon authority.why so?
Which groups does the user belong to?
Which groups have you configured in your DBM CFG?

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Jul 13 '06 #3
Hey Ian!!

Thanks a lot for reminding DB2_SNAPSHOT_NOAUTH ......i did used it
earlier, infact it was me who had set up that variable long time back
in the same server i mention in my post.

People say u forget things when u fall in love ;)
Ian wrote:
Dibur wrote:
Hi,

The way authorities are granted in DB2 are very vague.In one of our
production systems the users under staff group in AIX have sysmon
authorities and i have checked dbm cfg and there sysmon_group is empty.
So how every member of staff have sysmon authority.why so?

How can a user run "db2 list applications" and db2 "get snapshot ....."
with these authorities?

Is SYSADM_GROUP set to STAFF?

Is the DB2_SNAPSHOT_NOAUTH registry variable set?
Jul 15 '06 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Tom J | last post by:
I don't know who's monitoring these groups and sending the viruses (disguised as MS updates) to e-mail addresses of users on these groups...but I'm forwarding all the headers to the authorities......
6
by: B. Chernick | last post by:
(I'm not too comfortable with inheritance in VB and I don't think I've ever read about a situation like this.) Let's assume Dot Net 1.1 and VB.Net. Let's assume a main Winforms program and a...
7
by: akennis | last post by:
First of all, sorry for duplicating this post. I put it up in the alt.comp.lang.learn.c-c++ mistakenly. I'm investigating a problem whereby exceptions thrown from functions in a Shared Library...
0
by: ajos | last post by:
hello friends, what ive done is(in short) in my servlet class---> ArrayList<String> list=new ArrayList<String>(); while(resultset.next()) { s4 =...
1
by: pegasus3 | last post by:
I have a vague idea, however, this program is supposed to ask for a user number input, then another window will open with a number of squares (one inside the other) and they must have a color. ...
2
by: Chad | last post by:
The following question actually stems from an old Chris Torek post. And I quote from the following old CLC url ...
17
by: qartar | last post by:
As the title says, I am porting some code from MSVC (not sure which version, using Visual Studio 2008), which compiles without errors or warnings, to GCC 4.0 which generates a large number of generic...
3
by: chanshaw | last post by:
Alright I'm not sure if I worded the title correctly but I'm looking to generate a random number based on the numbers in an arraylist. So if I have the values 1,2,12,6 I would like to generate a...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.