Saving authority settings (BMC?)

Slot J.P.

Saving authority settings (BMC?)
Greetings fellow listers,

In my shop we have a database that is accessed by multiple
applications. The Data is taken care of by image copies and backup of
loadfiles. The DDL is saved by a datamodelling tool (Sybase Data
Architect). BMC Change manager is used to implement DDL changes
into the different environments (development, test and production).
After a change we a baseline of the structure, to make sure there's an
easy way to fall back. Within BMC Change Manager it is not possible
to only save the authority settings. If I want to save those I have to do
a full recovery baseline. Is there an easy way to save only the
authorisations?

Regards,

Jaap Slot,
Sr. DB2 DBA,
Rabofacet BV,
Zeist, Nederland

phone: +31 30 2152220
fax: +31 30 2151921
mobile: +31 6 53740167

-- my opinions only .... etc.. ----



Terri Melian

FW: Saving authority settings (BMC?)
(in response to Slot J.P.)
One of the consultants I work with does installation and training for BMC
Software's Change Manager and Catalog Manager. He does not currently
subscribe to the list, so I passed your question along to him. Here is his
reply:

There is a way to do this but it will take some editing of the worklist. The
way I use to do this is as follows:

****************************************************************************
********************
Let's say you want to save the authority settings in production for all
tables under a particular database.
I would do the following:

1. Do a Alter against the database and change the database name. This will
force a drop and recreation of all the dependencies which will
include all of the authorizations.

2. After the Analysis is completed and the worklist is generated, you can
edit the worklist and remove everything except the authorizations.
This worklist can then be used as input to the Execution when needed.

Another way to do this is using Catalog Manager. Pull up the database and do
a HGRANT next to the database and it will generate all
of the authorizations for that database. It also gives you the capability to
write the authorizations out to a dataset that can be used as input
to SPUFI etc... This is more automated provided the client has Catalog
Manager. If not, the above steps (1) and (2) is another alternative.
****************************************************************************
*******************

If you'd like to contact him directly, his email is [login to unmask email]

Terri Melian
Engagement Manager--OS/390 Products
BMC Software Professional Services
Office: 504-283-9574 or 800-841-2031 x34798
Fax: 504-282-7916
Cell Phone/Pager: 504-616-7916
Email: [login to unmask email]


-----Original Message-----
From: [login to unmask email] [mailto:[login to unmask email]
Sent: Wednesday, January 05, 2000 6:01 AM
Subject: Saving authority settings (BMC?)


Greetings fellow listers,

In my shop we have a database that is accessed by multiple
applications. The Data is taken care of by image copies and backup of
loadfiles. The DDL is saved by a datamodelling tool (Sybase Data
Architect). BMC Change manager is used to implement DDL changes
into the different environments (development, test and production).
After a change we a baseline of the structure, to make sure there's an
easy way to fall back. Within BMC Change Manager it is not possible
to only save the authority settings. If I want to save those I have to do
a full recovery baseline. Is there an easy way to save only the
authorisations?

Regards,

Jaap Slot,
Sr. DB2 DBA,
Rabofacet BV,
Zeist, Nederland

phone: +31 30 2152220
fax: +31 30 2151921
mobile: +31 6 53740167

-- my opinions only .... etc.. ----



Sibimon Philip

Re: Saving authority settings (BMC?)
(in response to Terri Melian)
We have CATALOG MANAGER 5.4.02. I am not able to do HGRANT. It is giving
UNKNOWN COMMAND error. Also I checked BMC's Catalog manager command
reference and I do not see this command. Is our version old?

thanks
Sibimon Philip
972-702-2515 - Office
972-417-3597 - Residence
E-mail - [login to unmask email]



-----Original Message-----
From: Melian, Terri [mailto:[login to unmask email]
Sent: Thursday, January 06, 2000 11:22 AM
To: [login to unmask email]
Subject: FW: Saving authority settings (BMC?)


One of the consultants I work with does installation and training for BMC
Software's Change Manager and Catalog Manager. He does not currently
subscribe to the list, so I passed your question along to him. Here is his
reply:

There is a way to do this but it will take some editing of the worklist. The
way I use to do this is as follows:

****************************************************************************
********************
Let's say you want to save the authority settings in production for all
tables under a particular database.
I would do the following:

1. Do a Alter against the database and change the database name. This will
force a drop and recreation of all the dependencies which will
include all of the authorizations.

2. After the Analysis is completed and the worklist is generated, you can
edit the worklist and remove everything except the authorizations.
This worklist can then be used as input to the Execution when needed.

Another way to do this is using Catalog Manager. Pull up the database and do
a HGRANT next to the database and it will generate all
of the authorizations for that database. It also gives you the capability to
write the authorizations out to a dataset that can be used as input
to SPUFI etc... This is more automated provided the client has Catalog
Manager. If not, the above steps (1) and (2) is another alternative.
****************************************************************************
*******************

If you'd like to contact him directly, his email is [login to unmask email]

Terri Melian
Engagement Manager--OS/390 Products
BMC Software Professional Services
Office: 504-283-9574 or 800-841-2031 x34798
Fax: 504-282-7916
Cell Phone/Pager: 504-616-7916
Email: [login to unmask email]


-----Original Message-----
From: [login to unmask email] [mailto:[login to unmask email]
Sent: Wednesday, January 05, 2000 6:01 AM
Subject: Saving authority settings (BMC?)


Greetings fellow listers,

In my shop we have a database that is accessed by multiple
applications. The Data is taken care of by image copies and backup of
loadfiles. The DDL is saved by a datamodelling tool (Sybase Data
Architect). BMC Change manager is used to implement DDL changes
into the different environments (development, test and production).
After a change we a baseline of the structure, to make sure there's an
easy way to fall back. Within BMC Change Manager it is not possible
to only save the authority settings. If I want to save those I have to do
a full recovery baseline. Is there an easy way to save only the
authorisations?

Regards,

Jaap Slot,
Sr. DB2 DBA,
Rabofacet BV,
Zeist, Nederland

phone: +31 30 2152220
fax: +31 30 2151921
mobile: +31 6 53740167

-- my opinions only .... etc.. ----








Libby Horton

Re: Saving authority settings (BMC?)
(in response to Sibimon Philip)
HGRANT was added in Catalog Manager 5.4.03, so it looks like you just missed
it. Sorry!
The current version is 5.4.05.

Best regards,
Libby Horton
BMC Product Support
1-800-537-1813

-----Original Message-----
From: Philip, Sibimon [mailto:[login to unmask email]
Sent: Thursday, January 06, 2000 12:05 PM
To: [login to unmask email]
Subject: Re: Saving authority settings (BMC?)


We have CATALOG MANAGER 5.4.02. I am not able to do HGRANT. It is giving
UNKNOWN COMMAND error. Also I checked BMC's Catalog manager command
reference and I do not see this command. Is our version old?

thanks
Sibimon Philip
972-702-2515 - Office
972-417-3597 - Residence
E-mail - [login to unmask email]



-----Original Message-----
From: Melian, Terri [mailto:[login to unmask email]
Sent: Thursday, January 06, 2000 11:22 AM
To: [login to unmask email]
Subject: FW: Saving authority settings (BMC?)


One of the consultants I work with does installation and training for BMC
Software's Change Manager and Catalog Manager. He does not currently
subscribe to the list, so I passed your question along to him. Here is his
reply:

There is a way to do this but it will take some editing of the worklist. The
way I use to do this is as follows:

****************************************************************************
********************
Let's say you want to save the authority settings in production for all
tables under a particular database.
I would do the following:

1. Do a Alter against the database and change the database name. This will
force a drop and recreation of all the dependencies which will
include all of the authorizations.

2. After the Analysis is completed and the worklist is generated, you can
edit the worklist and remove everything except the authorizations.
This worklist can then be used as input to the Execution when needed.

Another way to do this is using Catalog Manager. Pull up the database and do
a HGRANT next to the database and it will generate all
of the authorizations for that database. It also gives you the capability to
write the authorizations out to a dataset that can be used as input
to SPUFI etc... This is more automated provided the client has Catalog
Manager. If not, the above steps (1) and (2) is another alternative.
****************************************************************************
*******************

If you'd like to contact him directly, his email is [login to unmask email]

Terri Melian
Engagement Manager--OS/390 Products
BMC Software Professional Services
Office: 504-283-9574 or 800-841-2031 x34798
Fax: 504-282-7916
Cell Phone/Pager: 504-616-7916
Email: [login to unmask email]


-----Original Message-----
From: [login to unmask email] [mailto:[login to unmask email]
Sent: Wednesday, January 05, 2000 6:01 AM
Subject: Saving authority settings (BMC?)


Greetings fellow listers,

In my shop we have a database that is accessed by multiple
applications. The Data is taken care of by image copies and backup of
loadfiles. The DDL is saved by a datamodelling tool (Sybase Data
Architect). BMC Change manager is used to implement DDL changes
into the different environments (development, test and production).
After a change we a baseline of the structure, to make sure there's an
easy way to fall back. Within BMC Change Manager it is not possible
to only save the authority settings. If I want to save those I have to do
a full recovery baseline. Is there an easy way to save only the
authorisations?

Regards,

Jaap Slot,
Sr. DB2 DBA,
Rabofacet BV,
Zeist, Nederland

phone: +31 30 2152220
fax: +31 30 2151921
mobile: +31 6 53740167

-- my opinions only .... etc.. ----