创建登陆和数据库用户.sql

QL SERVER 应用开发 银行ATM(取款机）系统 数据库设计 我在学校的 SQL项目,模拟 银行ATM(取款机）系统

use bankDB
exec sp_addlogin 'sysAdmin','1234'
exec sp_grantdbaccess 'sysAdmin'
grant select,insert,update,delete on userInfo to sysAdmin
grant select,insert,update,delete on cardInfo to sysAdmin
grant select,insert,update,delete on transInfo to sysAdmin
GO

select * from userInfo
insert into userInfo(customerName,PID,telephone,address)values('张宝奎','37081119870121251X','0538-6014668','泰山学院')
update userInfo set customerName='奎子' where customerName='张宝奎'

select * from view_userInfo
select * from view_cardInfo
select * from view_transInfo
GO