Nov
16
SYBASE 에서의 사용자 추가 방법
sp_addlogin ‘아이디’,’패스워드’
sp_adduser ‘아이디’
sp_dropuser ‘아이디’
% isql -Usa -Ppassword -Sservername
1> use master
2> go
1> sp_addlogin scott, tiger, test
2> go
1> use test
2> go
1> sp_adduser scott
2> go
exec sp_addlogin ‘homeusr’, ‘password’, @defdb=’ebaihome’, @auth_mech = ‘ASE’
exec sp_locklogin ‘homeusr’, ‘unlock’
go
use ebaihome
go
exec sp_adduser ‘homeusr’ ,’homeusr’ ,’public’
go
——————————————————————————————————————————————————
출처 : http://benelog.springnote.com/pages/349014
