Page 1 of 1

Table name for User Authorisation

Posted: 13 May 2014 2:18
by SKSKD
I want to extract all the data for the control-M users and and to which group they belongs to in Control-M 6.3.
So thanks to let me know what will be table name in the control-M server schema.

Thanks
SKSKD

Posted: 19 May 2014 4:29
by ThePirate
The Schema poster is on the BMC FTP site ftp.bmc.com username "anonymous" password 'anything' at /pub/control-m/opensystem/DB_Schemas/ I would think it is one of the tables in the Security Definitions area. Best I can do.

Posted: 19 May 2014 7:14
by DocGoo
Try these two tables:

GENERALAUTHORIZATIONS

USERSGROUPS