Setting up a user in SQL Server can only access a particular attempt (to an external call) other than the no permission setting

--Current database creation role
exec sp_addrole ' Rapp '
--Assign View permissions GRANT SELECT on veiw to [role]

--Specify the View list Viewcardbaseinfo
--grant SELECT on v_city to Rapp
--grant SELECT on V_LP to Rapp
--grant SELECT on v_qy to Rapp

GRANT SELECT on Viewcardbaseinfo to Rapp


Go
--Add only users who are allowed access to the specified view: EXEC sp_addlogin ' login name ', ' Password ', ' Default database name '
EXEC sp_addlogin ' CD ', ' CD ', ' Campuscard '

You may not be able to do this here, require password strength, then you create it by hand

-----Control Panel-Administrative Tools---Local Security policy---account policy---Password policy-password complexity length set to Disabled

Go
--Add only users who are allowed access to the specified view into the RCRM role: exec sp_adduser ' login name ', ' username ', ' role '
EXEC sp_adduser ' CD ', ' CD ', ' Rapp '

Setting up a user in SQL Server can only access a particular attempt (to an external call) other than the no permission setting