473,324 Members | 2,214 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,324 software developers and data experts.

priviledges in db2

1
I want to give DBADM priviledge to a user in db2 V9.1 but not 'quiesce connect' which is implicitly provided to DBAdmin. can we not explicitly revoke 'quiesce_connect'from the user?
Sep 23 '10 #1
1 1638
vijay2082
112 100+
First thing DBADM is not a privilege but an authority and it allows users to perform privileged action against the database.

http://publib.boulder.ibm.com/infoce...c/c0005521.htm

If you are planning for restricting privileges, specifically in your case then individually grant the authorities and privileges to the user, rather than giving DBADM.

DBADM authority was tailored made that provides users with database admin privileges and quiesce is an integral part.
Cheers, Vijay
Sep 24 '10 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Helmut Jarausch | last post by:
Hi, to use a port below 1000 on a Unix system one needs root priviledges. But it's dangerous to execute all of a script under those priviledges. Therefore I'd like to drop the root priviledges...
4
by: Patricia | last post by:
Hi guys, I have been told that only users with SA priviledges could check the status of a job. For this reason, I had to give SA priviledges to this user so he could check the results of a job...
2
by: J.Beaulieu | last post by:
Hi I'll have probably to use sql server soon but prior to that I have a question concerning priviledges and security. Is it possible for someone to do like in access, ie creating a db/table...
0
by: tom | last post by:
how can I ensure my applicaton has high privelidges: I try and do something in a C++ console app and it works; I try and do something in a Visual C++ and it does not. thanks tom
11
by: Richard Myers | last post by:
Hello Im sure many of you have seen this error message before: For us its the third time this year. This error occurs seemingly at random. I have no idea what causes it too happen. None....
1
by: M. Simioni | last post by:
Hi, hi followed these KB: http://support.microsoft.com/default.aspx?scid=kb;en-us;Q271071 http://support.microsoft.com/default.aspx?scid=kb;en-us;Q317012 ASP.NET applications run without...
1
by: deathbydisco | last post by:
I've created a simple website with a login screen that requires an email address and a password. It uses the email ID and password to authenticate against active directory (just to see if the user...
2
by: Benny W | last post by:
Hello, I'm trying to start a monitor Windows server in my standalone Window PC. I use code like following: handle = ServiceWin32.OpenServiceA(SCManagerHandle, "MonitorServive", ...
24
by: proudlyphp | last post by:
I have no error message coming but the following code does not enter the trialentry into my table tblsug. The code is the following: <?php ob_start(); include...
1
by: 2desperate2usedesperate | last post by:
ERROR: You do not have SELECT privileges on sys.V_$PARAMETER view. This process cannot proceed. Hello, I am using ORACLE 10g Standard Edition and I am trying to configure the Oracle Designer for...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.