[SQL] sql user management

2001-05-28 Thread Vladislav Breus
With SQL requests I can create, change privileges of the user... Can I access to user information only with sql-requests ? - Is the user a member of group ? - Has he rights to table ? ---(end of broadcast)--- TIP 6: Have you searched our list ar

[SQL] sql user management

2001-05-28 Thread Vladislav Breus
With SQL requests I can create, change privileges of the user... Can I access to user information only with sql-requests ? - Is the user a member of group ? - Has he rights to table ? ---(end of broadcast)--- TIP 2: you can get off all lists at

[SQL] grant under sql92

2001-03-20 Thread Vladislav Breus
I have postgresql-7.0.3 I'm trying to do following : test=> create table test (col1 int,col2 int); test=> grant select on test (col1) to user1; ERROR: parser: parse error at or near "(" I'm trying to use GRANT with SQL92 extentions,(set permissions on the individual column) but it dosn't work