如何在所有数据库中一次添加用户？(Sybase-ASE)

Question

我想使用下面的命令sp_adduser一次将一个用户添加到所有数据库。什么查询可以一次访问所有数据库？在Sybase中通常可以做到这一点吗？

Answer 1

这可能在shell脚本中起作用：

user=<your new sybase user>

isql -U ${UID} -P ${PWD} -S ${SERVER} <<! | tee $0.out
set nocount on
go
declare cur cursor for select name from master..sysdatabases order by 1
go
declare @l_name varchar(30), @l_sql varchar(777)
begin
  open cur
  fetch cur into @l_name
  while @@sqlstatus = 0
  begin
    print @l_name 
    fetch cur into @l_name
  end
  close cur
  deallocate cur
end  
go
!

for dbname in `cat ${0}.out`; do
  echo "
use ${dbname}
go
sp_adduser ${user}
go
" >>${0}.sql
done

isql -U ${UID} -P ${PWD} -S ${SERVER} -i ${0}.sql