I have 470 new database accounts in SYBASE ASE I certainly don't want to do it manually since it is definitely time consuming. Here by I have old script which I try to add logins Can someone help to me write this script in another way? SCRIPT : source /cis1/sybase/SYBASE.sh
set passs= isql -Usa -SPDSQTS1 <<EO_SQL $passs declare a varchar(10) declare n int declare count int declare Iuser varchar(10) declare date varchar(20) declare id int count=1 while n<427 a=sed -n 'count{p;q;}' "/tmp/addthese.txt" select Iuser=name from syslogins where name='a' if [Iuser!=a] sp_addlogin a,Sybase123 go use qts_db go sp_adduser a,a,eng go use engcomdb go sp_adduser a,a,eng go use sybasedb go sp_adduser a,a,eng go use engdb go sp_adduser a,a,eng go use msgdb go sp_adduser a,a,eng go use master go sp_modifylogin 'a',"authenticate with","ldap" go select id=suid from syslogins where name='a' select date=crdate from syslogins where name='a' use qts_db go insert into dbo.profiles(login_name,userid,security_level,delta_ts,delta_sy_user) values ('a',id,'ADMIN','date',id) go insert into dbo.users(userid,site_id,delta_sy_user,delta_ts,email,displayname,lastname,firstname) values(id,'SYBASE',10407,'date','a',', : id','', '') go end count=count+1 end |
This forum is for SQL Anywhere, not ASE. They are vastly different products, like aircraft and donkey carts.
Love the order of your comparison - and the first is often a stealth fighther, as we know:)