Membru cu cele mai relevante răspunsuri
I've created APPLICATION ROLE like this
CREATE APPLICATION ROLE [AppRole1] WITH DEFAULT_SCHEMA = [dbo], PASSWORD = N'1'
Then I granted all the rights to this APPLICATION ROLE:
GRANT EXECUTE,SELECT,INSERT,UPDATE,DELETE,REFERENCES,ALTER,CONTROL TO [AppRole1]
Everything (SELECT, INSERT, UPDATE, DELETE ... on all tables,views ...) works great except for getting some data from another database (on the same server) that throws this error:
The SELECT permission was denied on the object 'MySynonym', database 'OtherDatabaseName', schema 'dbo'.
Note that I'm using SYNONYM to access table from other database
- Mutat de Tom Phillips 12 iulie 2012 19:41 Security question (From:SQL Server Database Engine)