How to give a grant any database object or any table to any user ??

[Former Member]

how to give a grant any database object or any table to any user ??

[pikakala_sebastian]

Check what access the existing SIDADM & ORASID or ant existing user has

Example

select granted_role from dba_role_privs where grantee = 'OPS$SIDADM';

select granted_role from dba_role_privs where grantee = 'OPS$ORASID';

grant connect, resource, sapdba to OPS$SIDADM;

grant connect, resource, sapdba to OPS$ORASID;

Hope this helps

Regards,

Sebastian

[DellSC]

That's if you're using Oracle.  If you're connecting to another database, you would have to use different syntax.  In either case, you need to work with your DBA to handle this.

-Dell

[former_member185603]

check with your DBA. Is it for DB access or BO access?

[Former Member]

it's DB access.