Enhancement: Improve the error messages of add-rule

[haozturk]

Enhancement Description

Following error messages has to be improved:

$ rucio add-rule --asynchronous --comment "CMSTRANSF-1036" cms:/WZTo3LNu_mllmin01_NNPDF31_TuneCP5_13TeV_powheg_pythia8/RunIIFall17MiniAODv2-PU2017_12Apr2018_94X_mc2017_realistic_v14-v4/MINIAODSIM 1 "T1_US_FNAL_Tape"
2024-11-25 11:58:15,446    ERROR    Access to the requested resource denied.
Details: Account transfer_ops can not add replication rule

fails since --ask-approval is missing.

$ rucio add-rule --asynchronous --comment "CMSDM-234" --lifetime 604000 --activity Debug cms:/ParkingBPH2/Run2018C-UL2018_MiniAODv2-v1/MINIAOD 1 "T2_US_MIT_Tape"
2024-11-22 16:43:29,890    ERROR    Access to the requested resource denied.
Details: Account transfer_ops can not add replication rule

fails since tape rules cannot have lifetime

Use Case

These error messages are misleading and doesn't give a clue to the user what's actually wrong.

Possible Solution

I haven't looked into the technical side of it, yet

Related Issues

@amanrique1 fyi