In SQL Server 2012, how can we give a permission to someone to have full control to SSRS and a permission to a specific Db so they can configure and run the SSRS reports and have a full control to backup/restore their Databases but do not have control to other databases on the same SQL Server machine?
How can we assign permissions to setup SQL Server Reporting Services
92 Views Asked by nam At
1
There are 1 best solutions below
Related Questions in SQL-SERVER
- Dynamic query creation with Array like implementation
- 'pyodbc.Cursor' object has no attribute 'callproc', mssql with django
- Driver com.microsoft.sqlserver.jdbc.SQLServerDriver claims to not accept jdbcUrl, ${SPRING_DATASOURCE_URL}: GitHub Actions
- PHP Laravel SQLServer could not find driver
- Upsert huge amount of data by EFCore.BulkExtensions
- How to locate relevant tables or columns in a SQL Server database
- Cannot delete SQL datafile (.mdf) as its currently in use
- Writing query in CTE returning the wrong output
- Group By Sum and without Group by sum Amount is different
- plan_handle is always different for each query in SQL Server Cache
- Adding a different string to a table fails
- The specified data type in the EF modelBuilder doesn't correspond to the one that is created
- SQL71561: SqlComputedColumn: When column selected
- How to Solve Error Associated with Trusted Authority
- SQL Server Data Model and Insert Performance
Related Questions in REPORTING-SERVICES
- SSRS cannot aggregate a variable
- How to filter data in a report using Microsoft Report Builder based on Orders of Service (OS) dates?
- Check if a value is not in a list in SSRS
- SSRS Report Builder returns error when entering more than one value in a parameter filter
- SSRS - Do not want to round a percent
- SSRS report exporting as PPT file
- SSRS use a dynamic SQL query with parameter
- Error when trying to change subscription owner (SSRS, SQL Server 2016)
- Background Colour Conditional Formatting in PBI Report Builder
- do you know any free reporting services like devexpress or boldreports?
- Embedded SSRS permissions error using rsweb:ReportViewer
- SSRS - Visual Studio round issue
- How to Implement Multi-Parameter Queries in SSRS Report Builder with Databricks ODBC?
- I want to integrate Crystal reports or SSRS reports in react js
- Column Grouping in SSRS report Matrix
Related Questions in SQL-SERVER-2012
- Able to initially retrieve string from varbinary but not able to retrieve it again after setting it from ascii file?
- ASP.NET Core web application running slow & occasionally timing out while running large queries to database after updating to .NET 8
- Connecting to API via Microsoft SQL Server 2012
- SQL Substring from a column of strings
- Sum time of consecutive rows with condition of filed
- Trying to delete records from a table that has 20 million records
- CROSS JOIN and STDistance to find closest point
- Getting the Penultimate Record from a Table Sorted by Descending ID
- Make 1 row result from two result using SQL Server
- How can I reliably store an ID so that I can use it in another INSERT statement?
- How can I add a whole column of data as a row?
- SQL loop invalid because no scalar variable?
- Not understanding why this .bat file is only pulling some XML info and not all
- SQL Hierarchy Fill Down
- Row Number to give same value when same partition
Related Questions in SQL-SERVER-ADMINISTRATION
- SQL Server 2019 user is dropped from database but error log says couldn't remove
- Blocking access to specific tables
- Active list of users in SQL Server SQL Database
- Default dbo schema for user from ACL group
- There is any option to run sp_addmessage in Google Cloud SQL Server
- SQL Server Agent new Job dependency on existing Step of an existing Job
- How to security access onprem database from Azure AppService
- I have problem when I config a distributed always on availability group
- Can SQL Azure Globan Admin & created user passwords be reset/changed?
- Extended Events and SQL Server Profiler
- Detaching a database as a backup strategy
- SQL Server Connection error: Setting IsolationLevel to ReadCommitted is not supported
- The transaction log for database 'tempdb' is full
- Prevent user from set DB to a single user mode
- Error message from database execution: Access to the remote server is denied because no login-mapping exists
Related Questions in SQL-SERVER-AUTHENTICATION
- postman server basic auth and bearer token
- Default dbo schema for user from ACL group
- Error when connecting to sql-server using windows authentication mode
- Cannot create new user in SQL Server
- Securing database credential with user, data database for mobile/web application
- How to pass parameter to a store procedure in openrowset and sql-server authentication
- What would be the connection string of a .Net Core web app that runs on Linux and connects to SQL server using an AD account
- Pyodbc is only accepting windows authentication
- node.js is not connecting to SQL Server database using SQL Server authentication
- Python pyodbc connect to Sql Server using SQL Server Authentication
- Connect Local SQL Server Database using Azure Active Directory Credentials
- VB code to connect to SQL server on windows server 2012R2 - not locally
- ColdFusion is not connecting datasource with SQL Server 2014
- How can we assign permissions to setup SQL Server Reporting Services
- SQL Server SA Password for SQL Server Authentication?
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular # Hahtags
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Lets say you create a sql user login called
sqllogin, Leave this user'sServer rolesaspublic.Under
Login Propertiessection for this user inUser Mappingselect the one database you want them against (in the list on rightside) and choose the following rolesNote: not all options are ticked in image.
This allows user login only to
tempdb(for this example) and not the others. They might be able to see other databases but cannot access them in anyway.More info on roles here
As far as SSRS is concerned, create a
datasourcemapped to this database with thissqllogin.This is not the same as permission to SSRS but only to the database they get access to.SSRS permissions are different, I'm pretty sure the sql login cannot be used. This might be of help Authentication SSRS.
But I hope this gets you started.