Results 1 to 3 of 3

Thread: Db2 SYSADM

  1. #1
    Join Date
    Jul 2014
    Posts
    294

    Unanswered: Db2 SYSADM

    Hi,

    My system name is XYZ, & during installation of Db2 C Express on my machine XYZ. I kept the username as db2admin.

    After connecting to the database as

    Connect to SAMPLE user db2admin ...

    List tables
    here I can't find any tables.

    Select current user from sysibm.sysdummy1
    db2admin

    If I connect to the same database as

    Connect to sample
    List tables
    here i can find all the tables under SAMPLE database.

    Select current user from sysibm.sysdummy1
    XYZ


    My question is ,
    1)Why Db2 server is showing all tables of sample under XYZ but not under db2admin.
    2)In this Scenario which is the SYSADM of my db2 server.is XYZ or db2admin.
    3)I want to add one more user(ABC) to my db2 server, so initially do I need to add that user to my windows users.

    kindly let me know these answers. I am new to this, as i got confused with this OS authentication.

    thanks in advance

  2. #2
    Join Date
    Sep 2013
    Location
    India
    Posts
    246
    You were login by which user while installing db2?

    post the output of:


    select * from table (AUTH_LIST_AUTHORITIES_FOR_AUTHID ('XYZ','U')) as T

    select * from table (AUTH_LIST_AUTHORITIES_FOR_AUTHID ('db2admin','U')) as T
    ssumit

  3. #3
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    Hi,
    Quote Originally Posted by HABBIE View Post
    My question is ,
    1)Why Db2 server is showing all tables of sample under XYZ but not under db2admin.
    2)In this Scenario which is the SYSADM of my db2 server.is XYZ or db2admin.
    3)I want to add one more user(ABC) to my db2 server, so initially do I need to add that user to my windows users.
    1. Have a look at the description of the LIST PACKAGES/TABLES command.
    FOR
    If the FOR clause is not specified, the packages or tables for USER are listed.

    2. Have a look at Defining which users hold SYSADM authority (Windows )
    3. Yes.
    Regards,
    Mark.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •