Browse by Tags

EXECUTE permission denied on object 'xp_sqlagent_notify', database 'mssqlsystemresource', schema 'sys'.

Published 27 May 8 3:48 AM | SSQA.net

Granting permissions to relevant account is a required criteria within the SQL Server databases management, for this even Reporting Services is not exceptional. As per the configuration by default the users connect to the report server by using their...

Filed under: sql server, databases, security, permissions, sqlagent, reporting services, reportserver, reportservertempdb, rsexecrole

Internal Tables in SQL Server 2005, what are they for?

Published 2 November 7 3:17 AM | SSQA.net

By default SQL Server automatically creates the internal tables for Full-text search, XML indexes and Service broker. These are also created when a user query is written poorly that uses tempdb heavily. At they are called internal tables but do not contain...

Filed under: sql server, indexes, security, search, xml, permissions, table, full-text, internal tables

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