> ôÁÍ ÅÝ£ ÈÉÔÒÙÊ ÚÁÐÒÏÓ ÄÌÑ ÓÍÅÎÙ ÐÒÁ× ÎÕÖÎÏ ×ÙÐÏÌÎÉÔØ...
>
insert into rdb$user_privileges(
  rdb$user,rdb$grantor,rdb$privilege,rdb$grant_option,
  rdb$relation_name,rdb$user_type,rdb$object_type)
select
  :new_owner,:new_owner,rdb$privilege,rdb$grant_option,
  rdb$relation_name,rdb$user_type,rdb$object_type
from rdb$user_privileges
where rdb$user=:old_owner
  and rdb$grantor=:old_owner
  and rdb$grant_option=1

ðÏÓÌÅ ÜÔÏÇÏ ÄÒÏÐÁÔØ ÐÒÁ×Á old_owner



Ответить