Browse by Tags

OLAP Connectivity from Pivot Table in Excel - security permissions

Published 25 September 7 4:14 AM | SSQA.net

Security permissions in OLAP is similar to normal OLTP based environment. Say if you are using Pivot Table object in MS Office Excel to display the reports using OLAP objects like Cubes. To achieve this it should connect to an OLAP Server and database...

Filed under: sql server, security, ssas, ssms, olap, excel, pivot, execute, credentials

Need to grant permission to view stored procedure text

Published 10 September 7 3:24 AM | SSQA.net

If you need to grant permissions to a login that only needs to view stored procedures (contents not just names of SP's). Further you may not want to grant that login with DB_OWNER or DB_DDLADMIN roles within that database, so how to achieve this task...

Filed under: sql server, security, update, permissions, stored procedure, schema, execute, view definition