>>>>> "rajan" == rajan <vgmonnet(at)gmail(dot)com> writes:
rajan> Andrew,
rajan> Another question, If the user student is not the owner of the
rajan> Schema(additional) and has only USAGE / no privileges, How come
rajan> it is able to modify permissions at schema level?
Because it's not modifying anything that affects any other user. If
"student" can't create objects in schema "additional", then the default
has no effect (since it applies only to objects created by "student");
if those permissions are later granted, then the previously set default
still applies.
--
Andrew (irc:RhodiumToad)