SQL Grant on - for multiple users

sql oracle select grant rights
Roman picture Roman · Aug 6, 2017 · Viewed 10.3k times · Source

i was curious if there was a way to grant multiple users simultaneously rights

Example: I want to give certain rights to multiple people that start with the letter AAR.

Usual grant on : GRANT SELECT ON Abteilung TO Herr_Mueller

How it goes for multiple people that start with AAR?

Answer

fhossfel picture fhossfel · Aug 6, 2017

If you have the list of users you can just append them to the statement:

GRANT SELECT ON Abteilung TO AAR1, AAR2, AAR3;

If you do not have the list ready your best bet is to do a select on all users to generate the statements necessary.

SELECT 'GRANT SELECT ON Abteilung TO ' || username || ';' FROM all_users WHERE username LIKE 'AAR%'

Then you just mark the result and execute them in a different session.

Related questions

DATEDIFF function in Oracle

I need to use Oracle but DATEDIFF function doesn't work in Oracle DB. How to write the following code in Oracle? I saw some examples using INTERVAL or TRUNC. SELECT DATEDIFF ('2000-01-01','2000-01-02') AS …

Read More
If statement in select (ORACLE)

Hi I have simply select and works great: select 'CARAT Issue Open' issue_comment, i.issue_id, i.issue_status, i.issue_title, i.ISSUE_summary ,i.issue_description, i.severity, gcrs.Area_name, gcrs.sector_name, substr(gcrs.stream_…

Read More
How to kill a running SELECT statement

How can I stop a running SELECT statement by killing the session? The command is continuously giving me output based on the SELECT statement, I want to stop it in between.

Read More