How Can Create User In Reporting Server 2005 And Assign To Role
how can create user in reporting server 2005 and assign to role
i convert reporting server to forms authentication
and i want create user from my applection and assign to role
thanks for all
View Complete Forum Thread with Replies
Related Forum Messages:
SP Error When Trying To Create User And Assign A Role
I get the following errors associated with trying to create an SP. Server: Msg 170, Level 15, State 1, Procedure AddFortuneUser, Line 8 Line 8: Incorrect syntax near '@newuser'. Server: Msg 137, Level 15, State 2, Line 1 Must declare the variable '@newuser'. Can anyone explain why I have to do a declare. I suspect I have to issue "declare @newuser sysname" somewhere but I'm not sure why. The following is the code I'm trying to run. My intent would be to create a form for the Admin Clerk that would call this SP. That way they can create a generic login. They have an application that allows them to change the password after the fact. /* Created for Admin person to allow them to add a basic SQL Login Account forcing the user to be a member of a specific role 'helmsman' in a specific database 'Fortune' */ CREATE PROCEDURE AddFortuneUser @newuser char(128) AS EXEC master..sp_addlogin @loginame=@newuser, @passwd =substring(@newuser,1,8), @defdb =Fortune GO if not exists (select * from dbo.sysusers where name = @newuser and uid < 16382) EXEC sp_grantdbaccess @loginame=@newuser, @name_in_db=@newuser GO exec master..sp_addrolemember @rolename ='helmsman', @membername =@newuser GO
View Replies !
How To Assign Execute Permission To Batch Of Stored Procs To A User/role
Just wondering if anyone knows of a useful command to assign execute permissions to a batch of stored procs to a user/role. I've got too many stored procs to manually go thru the steps of browsing for them and scrolling thru each one and clicking "execute" for each one. Also, would like to know if its possible to update a batch of stored procs that begin with a prefix like "spSomething_". Any info would be helpful! TIA.
View Replies !
Create User Roles In Reporting Server 2005
Hi, I would like to create the folders Sales, Orders and Credit under the Home folder. The Sales folder contains a set of reports that should be accessible to a group of users, similarly Orders folder contains a set of reports that should be accessible to a group of users. I do not have facility to create user groups in SQL Reporting Service. I create a user group in my machine (from Control Panel) but Reporting service is not able to view this group. I am able to add individual users to a folder, but I would like to check if I can create a group and then add users to this group. Any help in how to resolve this issue. Cheers,
View Replies !
Creating Databases Under MS SQL 2005 Server (SP-2): Dbo User Role
Good Day, I am having a problem with creating databases in MS SQL 2005 Server. When I attempt to assign an User Mapping for my SQL user account to the newly created database, the "dbo" user and schema is already assigned. When I try to drop this user in favor of my own, I receive an error message: Cannot alter the user "dbo" (Microsoft SQL Server, Error: 15150). I am connected to my database engine through the "sa" account. Regards, Keith
View Replies !
Create User - Permit In Database Role
Hi, I hv an application which is using ASP.net. The connectionstring in web.config is <appSettings> <add key = "constring" value = "Initial Catalog=mydatabase;Data Source=mypc-pc;User ID=User1; Password=password1"/> </appSettings>" Then, i hv created a user in SQL Server 2000 which is User1. What should i put for the database role? db_owner or just db_datareader and db_datawriter? pls help. Thnx
View Replies !
How To Assign Programatically One Task For A Role??
Hi everyone, I was wondering how can I do this programatically. I mean, to assign 'View Resources' task or delete 'Manage Resources' one. Tasks(2).TaskID = "2FBF7AE5-0DB6-46f2-B9BB-480794FBC97E" Is there any enumeration in Framework 2.0 in order to translate this sequence? From User Role Properties Window you perfectly can obtain a script but I haven't idea how do the same from a VB .NET application. Public Overridable Sub Main() SetRoleProperties End Sub Private Sub SetRoleProperties() Dim Name As String = "Explorador" Dim Description As String = "Puede ver carpetas, informes y crear suscripciones a informes." Dim Tasks(4) As Microsoft.SqlServer.ReportingServices2005.Task Tasks(0) = New Microsoft.SqlServer.ReportingServices2005.Task Tasks(0).TaskID = "E2723F22-E29C-496b-B981-1D775F45FC09" Tasks(0).Name = Nothing Tasks(0).Description = Nothing Tasks(1) = New Microsoft.SqlServer.ReportingServices2005.Task Tasks(1).TaskID = "993C580B-3FBF-444b-B85E-A8DA50ADF40F" Tasks(1).Name = Nothing Tasks(1).Description = Nothing Tasks(2) = New Microsoft.SqlServer.ReportingServices2005.Task Tasks(2).TaskID = "2FBF7AE5-0DB6-46f2-B9BB-480794FBC97E" Tasks(2).Name = Nothing Tasks(2).Description = Nothing Tasks(3) = New Microsoft.SqlServer.ReportingServices2005.Task Tasks(3).TaskID = "F95F31D0-834A-4c0e-B290-E3E4477908CA" Tasks(3).Name = Nothing Tasks(3).Description = Nothing Tasks(4) = New Microsoft.SqlServer.ReportingServices2005.Task Tasks(4).TaskID = "A1BDCA29-F891-418f-BEAA-43E937F800C4" Tasks(4).Name = Nothing Tasks(4).Description = Nothing RS.SetRoleProperties(Name, Description, Tasks) End Sub Thanks in advance for your time and links provided,
View Replies !
How To Drop A User Defined Database Role In 2005?
Using Studio, I created a user defined database role but I can not delete it because "TITLE: Microsoft SQL Server Management Studio ------------------------------ Drop failed for DatabaseRole 'test1'. (Microsoft.SqlServer.Smo) ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ The database principal owns a schema in the database, and cannot be dropped. (Microsoft SQL Server, Error: 15138) I am quite annoyed because the "owned schema" is db_owner, which can not be unselected. Quite an innovation. How do I drop this relationship?
View Replies !
One User Unable To Access The Reports From SQL Server 2005 Reporting Server.
I have deployed some reports on the reporting server, i have noticed that every one in the domain in which the reports are published can access the reports, except one user. when he tries to access the report he got the following error message or the blank report. "An error occured during report processing" "can no read the next data row for the data set dataset1". Although this user has all the roles on the reporiting server kike browser,content manager etc. i tried many things but still problem persists. Can anyone tell me the exact reason for this ? I shall be extremely thankfull.
View Replies !
2005 Reporting Service - Cannot Create Connection To Oracle Datasource On Web Server
created an Oracle datasource (tried both ole db & oracle client) in Visual Studio 2005 report project - works fine connecting and preview of report within ide , deployed to Reporting Services web server, received the following error when attempting to run the report on web server: An error has occurred during report processing. (rsProcessingAborted) Cannot create a connection to data source 'oracle'. (rsErrorOpeningConnection) System.Data.OracleClient requires Oracle client software version 8.1.7 or greater. web server has oracle client 9i client installed and connecting to db ok through sql plus (this server also is loaded with VS2005 and the SqlServer2005 db) any thoughts or direction greatly appreciated
View Replies !
User With Server Role
I have a user with DBCREATOR Server role only. That user is able to create database but create table permission denied. how would I set permission on this user, so that this user can create databases and automatically becomes the DBOWNER of that database and can do any action on that database. Thanks,
View Replies !
Checking The User's Server Role
I would like to determine if a particular user has sysadmin serverrole. Is there a way to do this via the connection string? Currentlyour code checks if a login is valid using SQLDriverConnect, however weneed to be certain that the user can login and modify the schema.Is it possible to fetch a user's server role to determine if it has asysadmin server role?
View Replies !
Backup User - Server Role?
I wish to create a user that can backup any or all databases in our SQLServer 2000 Instance. I thought there would be a server role for thisfunction, however I can only find that after I grant access of adatabase to the user, then I can choose ds_backupoperator.I want to create a user that will have the ability to backup all thedatabases. I dont wish to have to come back to the server after a newtable is created and add the backup user to that table.I want SA w/o the full privilage...am I crazy?Any Suggestions?TIARobBackgroup: We currently have about 10 SQL servers, and adding more inthe future. I am using SQLBackup from Idera along with HP SurestoreTape library (60 slots,2- DLT8000 drives with 40/80 GB capacity) withArcServe from Computer Associates. I want to have this automated tobackup to file then tape, regardless of what databases get created.
View Replies !
How To Generate All Grants To A User Role? (SQL Server 2000)
Using SQL Server 2000 I need to extract all the grants made to a usercreated role so that I can recreate the role in another version of adatabase and there are more grants than I want to do by hand. Doesanyone have SQL or T-SQL to perform this task that they would bewilling to share?I tried searching the archives but either I missed the post or what Iwant isn't posted.Thank you.Mark D Powell
View Replies !
How To Generate All Grants To A User Role? (SQL Server 2000)
I had thought that I had posted this yesterday but since I cannot findit here we go again.I have searched the archives but either the code I want is not postedor I missed it.I have a user create role in a database that I need to reproduce inanother version of the database. Does anyone out there have the SQLor T-SQL necessary to generate all the grants to a role?-- Mark D Powell --
View Replies !
SQL Server 7 Error 15023, User Or Role Exists
SQL Server 7 i did a restore of a database, then tried to add the User login to it, but when i select database access, i get the followinf error :- "Error 15023, user or role already exists ! the user did exist on the Database, but when i select Database,Users or Database,Roles the User doesn't exist !! so i can't drop it ! any ideas ??
View Replies !
Programmatically Adding A User To The System User Role
We have been working on an application that will be using a forms-authenticated report server (RS2005) as a reporting back-end. Using the reporting services web service I have been able to assign permissions to objects in reporting services no problem. The issue is that each user needs to be added to the System User role to be able to use the report builder properly. I can't seem to find a way to do this programmatically. Any idea?
View Replies !
How To Assign Password And User Id
Hi I have add one new database mdf file in my project by ---> add new Item in to project. But This database.mdf file is in windows authetication mode. So there is no password assign to this. I want to assign use id and password to this database or I want to give sql server authetication mode. I have tried Modfy Connection property of database but that is not working. what is the default username of this conncetion????? REply.....
View Replies !
How To Assign The View To A User?
im using the Northwind database, i use T-SQL commands to create a view that restricts users from seeing the address, city for all employees. i dont know how to assign the view to a user in the database using Enterprise manager. pls help me, im really needing a answer. thanks!
View Replies !
Adding A User/role To All User Database
Hi everyone, I try to add a db_role or a user to all my databases with one script. Although parsing doesn't report any problem I get a Syntax error during execution. I first select the database names into a #temp table which has two columns, ID and dbname. After that I use the following code: DECLARE @Count smallint declare @dbVarchar(20) SET @Count = 1 WHILE (@Count <=(SELECT MAX(ID) FROM #temp)) BEGIN Exec ("USE @db") EXEC sp_adduser 'test' EXEC sp_addrolemember 'my_role', 'testrole' SET @COUNT = @COUNT + 1 SET @db = (SELECT dbname FROM #temp WHERE ID = @Count) END It seems that the "Use @db" part has no value for the variable @db. Does anybody knows how to solve this?
View Replies !
How To Assign Database Access Privilege To User?
Hi friends, I have created a database DB1 using CREATE DATABASE DB1 command. Then i created login name using CREATE LOGIN login1 WITH PASSWORD = 'password1' command and created user name using CREATE USER user1 FOR LOGIN login1 command. Now i have to assign the user1 to the database DB1. Any one please tell me how to assign DB1 access privilege to user1? Thanks in Advance Sathish kumar D
View Replies !
Assign Numeric Data Type To User Variable
how to pass the column that has a numeric(12,0) data type to user variable in SSIS? what kind of variable data type should I choose? if i select int64, it keep giving me an error: Error: 0xC001F009 at Row by Row process: The type of the value being assigned to variable "User:bject_Key" differs from the current variable type. Variables may not change type during execution. Variable types are strict, except for variables of type Object. there is no numeric data type in variable.. if you click the drop down box in variable data type, you can only see the below data type: Int32 int64 Object Sbyte single string uint32 uint64 boolean byte char
View Replies !
SQL Reporting Services 2005 - Trying To Create A Border Only Every Fifth Row
I was wondering if anyone might have any insight into the following issue: I would like to have a bottom border of 'solid' for the entire row on every fifth row of one of my reports. The rest of the rows should have no bottom border. I know there must be an expression I can write to do this involving RowNumber but I can't seem to figure it out. Does anyone know how to make this happen?
View Replies !
Cannot Delete User In SQL 2005 Reporting Services
Hi, I have several reports for users to view on our Intranet. After SQL 2005 SP2 patch installed, I cannot delete user or user's authority from Report in Properties Tab. An error message was shown on the status bar. It indicated that JavaScript Error: 'Return' statement outside of function. Seems something wrong with the 'Delete' funciton in SQL 2005 after update. The other functions worked fine. Could you point me out how to fix it or need to install any updates. Thanks a lot! Regards, Kenneth Lai Programmer
View Replies !
SQL Reporting Services 2005: End User Deployment
Is there another way for users to access reports online besides the Report Manager? Or is there a way for users to go to a URL that does not include the server? The same question goes for Report Models and Report Builder. Can they access these features without access to the server and databases?
View Replies !
How To Assign User Variable Value To The Derived Column, In Data Flow Task
Hi: In the derived column transformation editor, I have a Derived column name called FileGroupID. I would like to pass in a value for this column from a variable that I have set earlier in the scope. Can someone let me know, how to write the expression that does that and where do I specifiy that expression. I am thinking its the expression field in the derived column transformation editor. My main question is how to actually write the expression, what is the syntax to pull the variable value? Thanks. MA2005
View Replies !
How To Create Radio Buttons For Parameters In Reporting Services 2005
Hello, I am creating a report that the user will pick a value from about 6 items. The project manager would like these values to be represented as radio buttons on the ReportViewer control. I am unable to determine how do create these 6 radio buttons. Here is a simple example to demonstrate what I need. Lets say the report returns the total number of fruit in a stores inventory. The choices are: Apple, Banannas, Oranges, Grapes, Cherries, Water Mellon. I have a variable @Fruit that I would like populated by the user and I want them to select which piece of fruit they want to see by selecting a radio button. Is there a way to do this using Reporting Services 2005 Report Designer? Thanks, Flea#
View Replies !
SQL Server 2005 / Securityadmin Role / SSMS
Experiencing a little weirdness with SQL Server Management Studio...Have created a login, that has fixed server role "securityadmin".The login can create/drop logins, add/remove them as users indatabases, etc.The login can change another login's password, using SQLfrom a query window (e.g. alter login bob with password='abc')However, the login *cannot* change another login's password,using SSMS GUI (e.g. "Security", "Logins", double-click "Bob",change password, say "OK"). The error text is:Change password failed for Login 'Bob'. (Microsoft.SqlServer.Smo)Additional information:An exception occurred while executing a Transact-SQL statement orbatch.(Microsoft.SqlServer.ConnectionInfo)Cannot alter the login 'Bob', because it does not exist or you donot have permission.(Microsoft SQL Server, Error: 15151)Has anybody else experienced this?
View Replies !
Web Application And Role Management In Sql Server 2005
Hi every body I'm developing a web application and i like to use the sql server 2005 role management features istead of developing a role management package in my program, I can do it on my tables and othe database items but I have no idea about using database access rights in my web pages to permit some one viewing or updating a web form... Is there any system table or system stored procedure showing access rights in my data base? or is there another idea to do this?? by Thanks Javaneh
View Replies !
SQL Server 2005 Application Role's Problem
Hi all. I have developed a VB6 program which will activate an Application Role to UPDATE and INSERT some tables in SQL Server 2005. My program will login with a username, say USER and then run with the rights of the Application Role which will SELECT, UPDATE and INSERT the following tables: 1) Table A 2) Table B 3) Table C The USER login is a restricted user which has only SELECT permission to Table A, B and C. I encounter a problem in which my program can only UPDATE table B and table C but Table A. I have double checked the settings of Table A, Table B and Table C. Theirs are all same. Fyi, the column which can't be updated is of type "datetime". Once i grant USER login UPDATE permission to Table A, my program works perfectly in which it can UPDATE all the tables including Table A. I have tried for almost 2 days but am still clueless. Any ideas? Thank you so much.
View Replies !
Reporting Services 2005 - Report Slow To Render For End User
We're using SQL Reporting services 2005 that connects to Analysing Services 2005 OLAP Cube that we have built. We've built reports using Microsoft Report Builder using a datasource mapped to our Cube. If the reports are run by a domain administrator, the reports take 4 to 6 seconds to run.. if i'm using a user that is not a domain administrator the report takes 2 minutes to render... it's the same report using the same machine with the same filter. We're using Windows Authentifications I Went into the ExecutionLog of the Report Server and the number are exactly showing what a just describe. DataRetreivalTime is the problem in this case but i'm not really sure how to correct the problem since that running the report as an administrator is working fine...
View Replies !
SQL Server 2000 And 2005 - Application Role - Sp_setapprole
Hi All, Is there any limitation for setting password to an approle (like it should be 8 character long, should not start with numbers) ? If so, what are those limitations ? Does the same is applicable for sp_setapprole which uses the same password ? please confirm, for both SQL Server 2000 and 2005 versions. thanks in advance, Regards, Kailai
View Replies !
What Role Should Be Given To The End User?
Hi Everybody, The end users are using VB Applications, there they will be entering datas. Those datas will be stored in the SMS Database. My Problem is through which Roles (Fixed Server Roles or Database Roles) I should attach these end users. If it is a Fixed Server Roles, Other than sysadmin role in which role I should attach this end user. Like that other than DB_Owner in which role I should attach these end users to the Database Roles. Can anyone guide me please. thanks, Srinivasan.
View Replies !
Create Database Role Via T-SQL
I have created the functionality to dynamically create databases and am now trying to figure out how to create database roles using T-SQL. I keep finding information about the sp_addrole stored procedure which is the first step, but how do you go about defining what permissions this role has via T-SQL? Thanks
View Replies !
Reporting Manager: ContentManager Role
Hi All, when I open the http://serverName/Reports/Pages/Folder.aspx, I dont see Contents and Properties tab underneath Home. When I click Site Settings, I see that I belong to System Administrator and System User Role. Do I have to be under Content Manager Role to see Contents and Properties tab? With System Adminstration role, shouldn't I be able to do everything( add myself under ContentManager role)? Isn't System Admin superset of all role? Where do I add myself under ContentManager Role? Thanks for your help Phewa Taal
View Replies !
User/Role Check
Can anyone out there help me write a sp to determine if a user has a certain role? I'm trying to use "sp_helpuser @UserName". Can I declare a cursor with "EXEC sp_helpuser @UserName"? I'm not having success with this. What about SELECT [GroupName] FROM EXEC sp_helpuser @UserName WHERE [GroupName] = @GroupName? Again, syntax error. Is there already a better way that someone knows of?
View Replies !
Create DB Role Owned By Public
I use the following script in order to create db role: USE [MyDB]GOCREATE ROLE [myRole] AUTHORIZATION [public]GO It doesn't work: Msg 15405, Level 16, State 1, Line 1 Cannot use the special principal 'public'. However this code works fine: USE [MyDB]GOCREATE ROLE [myRole] AUTHORIZATION [dbo]GOALTER AUTHORIZATION ON ROLE::[myRole] TO [public]GO So the question is why?
View Replies !
|
TRACKER
