Skip to main content

๐Ÿ‘ฉโ€๐Ÿ’ป ่ณ‡ๆ–™่กจๆŽˆๆฌŠ

่ชชๆ˜Žโ€‹

ๅฐ‡่ณ‡ๆ–™่กจๆŽˆๆฌŠ็ตฆๆŸๅ€‹ไฝฟ็”จ่€…๏ผŒๅฏ็”ฑๆญคๆŒ‡ไปค้€ฒ่กŒ

ๆต็จ‹โ€‹

1. ๆŽˆๆฌŠโ€‹

ๆญค่™•ๅฐ‡ Order ่ณ‡ๆ–™่กจๆŽˆๆฌŠ็ตฆ AP_User ไฝฟ็”จ

GRANT SELECT ON  [schema].Order TO AP_User;

2. ็ขบ่ชโ€‹

ไฝฟ็”จ AP_User ้€ฒ่กŒ้€ฃ็ทš๏ผŒ็ขบ่ชๆ˜ฏๅฆๅฏไปฅ้€ฃ็ทšๆˆๅŠŸ

SELECT * FROM [schema].Order