From: <ai...@ta...> - 2005-04-20 10:36:43
|
On Tue, 19 Apr 2005 16:28:03 +0000 (UTC), pr...@hm... ("Vladimir Tsvigun") wrote: Hi, >From source: > " where %s.rdb$%s = priv.rdb$relation_name\n" > " and priv.rdb$privilege = '%c' and priv.rdb$object_type = %d\n" > " and ( (priv.rdb$user = '%s' and priv.rdb$user_type = %d)\n" > " or (priv.rdb$user = 'PUBLIC' and priv.rdb$user_type = 8) ) ) > > Please, specify the rights of object which should be in the list >but it there is not present. > Probably I take into account not all of a condition It occurred to me that I actually never grant rights to specific users. I grant rights to roles and then connect with appropriate role. It looks like code above doesn't check does the current role has right to access to the object? Also the owner of the object is special - it has all rights to the object without need to grant them, so this should be checked too? ain |