Question Odbc Rights

[DBA_learner]

Hello All,

I want to create one user in _user table for odbc access and want to grant permissions similar to one existing user.

Example:-

One user "cust" has read/write permission on multiple tables, now I want to create one new user and want to give similar rights like cust user.

Is there any direct/easy way of doing so rather then checking all permissions of cust user and grant permission to new user for each table manually.

Kindly suggest.

Regards

 

[Rob Fitzpatrick]

OpenEdge version?

 

[DBA_learner]

Sorry forgot to mention, it's 10.2b.

 

[DBA_learner]

Hi @Rob Fitzpatrick, do you have any update on this?

Kind Regards

 

[RealHeavyDude]

Please see my answers here Odbc For Progress 11.6

Heavy Regards, RealHeavyDude.

 

[DBA_learner]

Hello @RealHeavyDude,

Sql is already installed and running fine. We want to create one user under _user table and want to give permission similar to one existing user.

One way of doing so, we have to list all permissions of that existing user (read/write/delete for all tables) and give the same to new user. Is there any easy way to copy all of the permissions of existing user to new user.

Kind Regards

 

[TomBascom]

Is there any easy way to copy all of the permissions of existing user to new user.

No.

 

[RealHeavyDude]

There is no built-in functionality to clone user permissions. Unless you roll your own - which might be highly application specific - this is a manual taks.

Heavy Regards, RealHeavyDude.

 

[DBA_learner]

Ok thank you Rob and Tom!!!

 

[Rob Fitzpatrick]

Ok thank you Rob and Tom!!!

RealHeavyDude and Tom, actually.

 

[DBA_learner]

thanks RealHeavyDude!!!