0

How to check which all users have access to which all databases in the system?

For example: In my system there are databases like abc, def, xyz.. and there are database level users user1, user2, user3 .., now i want to check whether user1 can access which all databases.

Im using Redshift database.

Craig Ringer
  • 307,061
  • 76
  • 688
  • 778
DJo
  • 2,133
  • 4
  • 30
  • 46
  • Did you check this -> http://stackoverflow.com/questions/22523273/how-to-find-out-what-are-the-privileges-granted-to-one-group-in-redshift – Techidiot Sep 24 '15 at 05:07
  • Also check http://stackoverflow.com/questions/18741334/how-do-i-view-grants-on-redshift – Techidiot Sep 24 '15 at 05:09
  • 1
    x-posted to http://dba.stackexchange.com/q/116002/7788 – Craig Ringer Sep 24 '15 at 05:43
  • @Bhush_Techidiot, Imgetting the query output as 0 Rows. – DJo Sep 24 '15 at 06:05
  • 1
    First of all, you were offered *two* similar questions with the total of *three* answers, so *which* query returned 0 rows for you? Secondly, did you try to understand the mechanics of the query you were running so that you could try and adapt it for your needs? I hope you will accept the fact that not every code snippet found on the Internet is supposed to work for you as is, without some additional work applied to it. – Andriy M Sep 24 '15 at 06:45
  • 1
    And last, but not least, please don't cross-post the same question on different SE sites. Choose one location; if you aren't happy with the response, flag it for migration to a different site. As it stands, one of the two copies of your question is likely to be closed soon. – Andriy M Sep 24 '15 at 06:49

0 Answers0