cancel
Showing results for 
Search instead for 
Did you mean: 

How to change system user validity in Hana

Mithran
Participant
0 Kudos

Dear Guru's,

Currently we had a requirement to lock system id in hana sps12. We created a new id similar to system id and we set the validity for system id. All was working fine. But after a month system copy id was not working. We tried several times since system id also was with expired validity we could not check further. So we waited for 24 hours and system copy id started to work. Inorder to overcome these problema in future waht can be done ?

We tried to assign user admin privilege to sap schema id but error throws stating no authorisation.

Is it possible to assign user admin privilege to sap schema id.

We were able to change validity for system id, but unable to assign user admin privilege to sap schema id.

Kindly suggest

Thanks and Regards,

Mithran

pfefferf
Active Contributor
0 Kudos

What do you mean with "... assign user admin privilege to sap schema id ..."? The user admin privilege is a system privilege and not an object privilege, so it cannot be assigned to a schema or for a schema. It is assigned to a user or a role.

Mithran
Participant
0 Kudos

Hi Pfeffer,

Since system id we have set the validity, in order to overcome future problems incase we face any problems. We thought to assign "user admin" sustem privilege to sap schema id for example system schema is "sapmt1". To this id we tried to assign.

Thanks and Regards,

Mithran

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member209962
Participant
0 Kudos

Hi Mithran,

Best approach would be create a user and assign required roles (depending on the task you perform ) along with user admin role. Then deactivate SYSTEM user, if any time you need SYSTEM user you can activate it.

deactivate

alter user system deactivate user now

activate

alter user system activate user now

Thanks

Tabrayz