473,772 Members | 2,420 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Gibt es eine DB2 Funktion/Abfrage oder View um die User/User Group abzufragen?

Moin,
gibt es eine DB2 Funktion/Abfrage oder View um die User/User Group
abzufragen?
Ich möchte in meiner Anwendung abfragen ob der eingeloggte User
bestimmte Rechte auf der Datenbank hat.
Kann man diese Rechte abfragen?
In welcher Tabelle stehen diese?

Ingo
Nov 12 '05 #1
1 4837
Ingo Kollesch wrote:
Moin,
gibt es eine DB2 Funktion/Abfrage oder View um die User/User Group
abzufragen?
Ich möchte in meiner Anwendung abfragen ob der eingeloggte User
bestimmte Rechte auf der Datenbank hat.
Kann man diese Rechte abfragen?
In welcher Tabelle stehen diese?

Ingo

Ingo,

You can use the USER special register and join it with the views
containing *AUTH* in their names. Note that DB2 has no direct means to
associate a USER with a group. I think this requires an API call (which
I don't know unfortunately).

Cheers
Serge

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

Nov 12 '05 #2

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

Similar topics

3
2290
by: jagg | last post by:
Hi, i save junior football results in a mysql table (FIELDS id jugend autor sptag ergebnis spdatum zeit ) With the following lines I generate a site whichs gives me ALL results Code: <table border="0" cellspacing="1" cellpadding="2" class="content" width="100%">
0
438
by: Mark | last post by:
My question is very general, but to properly explain it, i will ask a specific one. In our SQL 2000, .NET based application we have as a Device table, which lists all the devices. That device table has many child tables storing all kinds of information (Software, Hardware, Windows Events even). However there is a desire to group many devices into groups. The devices that belong to a certain group can be hand picked by the user. Also, we...
12
2645
by: Neil | last post by:
I previously posted re. this, but thought I'd try again with a summary of facts. I have an Access 2000 MDB with a SQL Server 7 back end. There is a view that is linked to the database via ODBC and has been in place for several years without any performance problems. Recently I added a couple of fields to the output of the view, and it became very slow when scrolling. When just opened in the database window, the linked view takes about...
1
3696
by: Marcel | last post by:
Es soll aus einem Access 2002 AddIn (VBA) heraus eine Excel-Datei geöffnet und möglichst direkt gedruckt werden. Der Dateiname der Excel-Datei ist bekannt. Zuvor oder dabei, sollen VBA-Daten in bestimmte Zellen der Datei geschrieben werden! Wie kann ich das umsetzen??? Vorab Danke für Eure Hilfe. Marcel
1
2697
by: QB | last post by:
Hallo dies ist mein erster Post. ICh möchte eine kleine Applikation schreiben, welche es mir ermöglicht auf eine Access DB die Tabellen zu aktualisieren. Die ^Schwierigkeit für mich dabei besteht, dass die Tabellen die uptodate sind, in verschiedenen anderen Access DB sind...
7
3457
by: MIKQ | last post by:
Hi, ich habe ein eindimesionales Array dessen ca. 5 Werte (01234) ich in _eine_ Zelle schreiben will. Um in Excel zu schreiben habe ich folgende Sub geschrieben: Private Sub ExcelAusgabe(ByVal Wert() As Integer) Dim xlApp As Excel.Application
1
1331
by: rdemyan via AccessMonster.com | last post by:
When users are setup in my app, the administrator can restrict the products that are available for viewing by the user. I have a table, Table 1, that lists the User Name, Product ID and Viewing Allowed (True/False) for each product. But here's the problem. What happens when new products are added? Administrators don't want to have to go in each time and activate those new products for viewing. How do I best handle this? I was thinking...
10
4521
by: Sean Chambers | last post by:
Hello, I am attempting to utilize the MVP pattern in a new app I am building. I am using TDD, along with mock views attached to the View interface to attempt to unit test the UI. The problem I am having is when using the InitView() of the presenter, normally I would be retrieving data from NHibernate when InitView is called. Therein lies the problem, I can't seem to figure out how to properly
1
1642
by: Troels Arvin | last post by:
Hello, Quoting http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/topic/ com.ibm.db2.luw.sql.ref.doc/doc/r0000935.html : Group privileges are not considered for any table or view specified in the CREATE VIEW statement. I discovered this today because a user complained that she couldn't create a simple view referring to a table to which she had all privileges.
0
9619
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
10103
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
9911
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
8934
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
6713
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5354
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5482
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
3609
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2850
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.