Mercurial > gemma
comparison schema/manage_users_tests.sql @ 247:946baea3d280
Add view to list user profiles with role
To be able to GRANT privileges ON ALL TABLES IN SCHEMA,
use auth.sql last during database setup.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Thu, 26 Jul 2018 19:33:42 +0200 |
| parents | 55dce2f649bc |
| children | 92470caf81fd |
comparison
equal
deleted
inserted
replaced
| 246:299568ad3c37 | 247:946baea3d280 |
|---|---|
| 12 $$, | 12 $$, |
| 13 42501, NULL, | 13 42501, NULL, |
| 14 'Less privileged user cannot call function in schema sys_admin'); | 14 'Less privileged user cannot call function in schema sys_admin'); |
| 15 | 15 |
| 16 SET SESSION AUTHORIZATION test_sys_admin1; | 16 SET SESSION AUTHORIZATION test_sys_admin1; |
| 17 | |
| 18 -- | |
| 19 -- Role listing | |
| 20 -- | |
| 21 SELECT isnt_empty($$ | |
| 22 SELECT * FROM sys_admin.list_users | |
| 23 $$, | |
| 24 'List of users can be queried'); | |
| 17 | 25 |
| 18 -- | 26 -- |
| 19 -- Role creation | 27 -- Role creation |
| 20 -- | 28 -- |
| 21 SELECT lives_ok($$ | 29 SELECT lives_ok($$ |