Security Setting For Creating, Trainning Session Model With ASP.NET Front-end AP

Jan 30, 2008

Hi,
I would like to demonstrate mining temporary models in an ASP.NET application.

Creating, trainning, predicating actions are all witten at C# codes as follows:





Code Snippet

using (AdomdCommand cmd = new AdomdCommand())
{
// Build temporary mining model
cmd.Connection = asConn;
cmd.CommandText = "CREATE SESSION MINING MODEL " + modelName +
" (" +
"HCVS_MemberId Text KEY," +
"HCVS_MeasureDate DATE KEY TIME, " +
"SysPressure LONG CONTINUOUS PREDICT, " +
"DiaPressure LONG CONTINUOUS PREDICT," +
"Pluse LONG CONTINUOUS PREDICT" +
") " +
"USING Microsoft_Time_Series(Missing_Value_Substitution='Mean' ) "; // Periodicity_Hint = '{12}'
cmd.ExecuteNonQuery();

// Train Data
cmd.CommandText = "INSERT INTO " + modelName + " (HCVS_MemberId, HCVS_MeasureDate, SysPressure, DiaPressure, Pluse) " +
"OPENQUERY([Healthcare], " +
" 'SELECT HCVS_MemberId, HCVS_MeasureDate, SysPressure,DiaPressure,Pluse" +
" FROM v_VitalSignForecast WHERE HCVS_MemberId=''" + id + "'' AND HCVS_MeasureDate>=''" + from.ToShortDateString() + "'' AND HCVS_MeasureDate<=''" + to.ToShortDateString() +"'' ')";

cmd.ExecuteNonQuery();
// Predict upon the Train Data. In addition, the standard deviation of each predicated value is retrieved
cmd.CommandText = "SELECT FLATTENED " +
"( SELECT *, " +
" SysPressure + PredictStdev(SysPressure) AS [SysPressure_PlusStdev], " +
" SysPressure - PredictStdev(SysPressure) AS [SysPressure_MinusStdev] " +
"FROM PredictTimeSeries(SysPressure, " + fDays + ") AS SysTable " +
") " +
"FROM " + modelName ;


AdomdDataAdapter adapter = new AdomdDataAdapter(cmd);

DataSet sysDS = new DataSet();
adapter.Fill(sysDS);
The problem is that I do not know how to configure my Analysis Service Server to let ASP.NET account can utilize it. And ASP.NET account in trun impersonates the account who is authorized to use Healthcare DB in the Openquery. Please give a help. Thanks a lot.

Ricky.

View 4 Replies


ADVERTISEMENT

SSRS -- Security Filter And Model Item Security Setting

Jul 31, 2007



Hi,


I have posted this issue for a week, haven't got any reply yet, I posted it again and desperately need your help.


The article http://msdn2.microsoft.com/en-us/library/ms365343.aspx says:
Model Item Security can be set for differnt security filters, but when I use SQL Server Management Studio to set Model Item Security, it seems "Permissions" property surpass "Model Item Security" property. -- My report server is using Custom Authentication.



For example, in "Permissions" property of the model, if I checked "Use these roles for each group or user account" without setting any user or group, no matter what users I added to "Model Item Security" with "Secure individual model items independently for this model" checked, NO one user can see the model on report manager and report builder;

in above situation, if I added "user1" and gave role such as "Browser" role to "user1" in "Permissions" property, if I checked "Secure individual model items independently for this model" in "Model Item Security" property, even I did NOT grant "user1" to root model and any entities under the model, the "user1" is able to access the model and all entities in report builder.



My question is on the same report model, how to set "AdminFilter" (empty security filter) for administrator permissions and set "GeneralFilter" (filtered on UserID) for general user based on their UserID?


The article also says:

"Security filters are always applied, even for users who have Content Manager or Administrator permissions to the model. To allow administrators or other users to see all rows of an entity on which row-level security is defined, you can create an empty security filter (which always returns True) and then use the filter to grant those users access to all the rows."



So I defined 2 filters "GeneralFilter" and "AdminFilter" for "Staff" entity for my report model "SSRSModel", I expect after I deployed the report model, the administrator users use report builder to build reports with all rows available, and the non-admin users can only see rows based on their UserID.



I can only get one result at a time but not both:

either the rows are filtered or not filtered at all, no matter how I set the "SecurityFilter" for the entity: I tried setting both "AdminFilter" and "GeneralFilter" for SecurityFilter at the same time, combination of "DefaultSecurityFilter" and "SecurityFilter", or one at a time.



Your help is highly appreciated!

Desperate developer

View 1 Replies View Related

Model Item Security Setting

Jan 4, 2008

Hi
I just deploy a report model and want use report builder to create ad-hoc using this report model.
I want some entitis and attributes are not visiable for some user, so I config the model item security for this model.
But no matter which user I use to login the report server, I always can access all the entities.
Even I delete all the groups and users in "Permissions" property of the model, I still can access this model through report builder.
All the user I used to test are local user of server with report service, my server is SQL Server 2005+SP2.

How can I fix it?

View 3 Replies View Related

Create Session Model With Missing Value Parameter

Jan 28, 2008

Hi, I created a Session model via the following

CREATE SESSION MINING MODEL test
(
HCVS_MemberId Text KEY,
HCVS_MeasureDate_Float LONG KEY TIME,
HCVS_MeasureDate Date Discrete,
SysPressure LONG CONTINUOUS PREDICT,
DiaPressure LONG CONTINUOUS PREDICT,
Pluse LONG CONTINUOUS PREDICT
) USING Microsoft_Time_Series ;

How do I specify that I would like to Mean to fill the gap of missing values?

Thanks,
Ricky.

View 1 Replies View Related

Setting A Schema Context For A Session

Apr 25, 2006

Is there a way to specify a given Schema as the currently active one for a given database session ? i.e. im looking for somthing like:

Use Schema=<name>

Execute Queries / Stored Procs, etc

.....

I want all the Queries and Stored Procs to execute on the Schema set initially.

I can't use the Default_Schema on the User to do this due to certain restrictions in the way we create users and Schemas.

I know that i can always qualify the objects in the Queries with a Schema Name, but i have a requirement where the Queries need to be generic in nature and need to run on one of many identical schemas in the Database. Is this Possible in Sql Server?

Any help will be greately appreciated.

Thanks

View 3 Replies View Related

SQL 7 Security And Access 97 Front End

Jan 26, 2001

I am using Access 97 as a front end to access SQL 7 server on NT 4.0 server.
I've set up security model based on NT authentication only. Users have login right to login to SQL and they have public & dataread & denydatawrite access. They also have SELECT permission on a table object and have no permission to INSERT, DELETE and UPDATE.
When I use Access 97 to access a database, users are still capable of inserting and deleteing records in tables.

Am I doing something wrong?

Thanks, Michael.

View 1 Replies View Related

Setting And Getting User-Specific Data In A Session

Oct 19, 2000

Hi:

I like to know how I may store some user-specific data at the beginning of a session and retrieve the same data later during the session in a SQL command. For those of you familiar with ORACLE, I am trying to mimic the SET_CLIENT_INFO and GET_CLIENT_INFO functions of ORACLE's DBMS_APPLICATION_INFO package on SQL Server.

Any suggestions?

thanks,
Peter

View 1 Replies View Related

Error 1413 During Setting Up Mirroring Session

May 28, 2007

hi guys , does anyone of you have a good solution on the Error 1413: Communications to the remote server instance failed before database mirroring was fully started issue?



Best Regards,

Hans

View 1 Replies View Related

Front End - Best Tools For Creating?

May 21, 2008

Clearly, I'm very new to this.

Does anyone have a favorite tool/system for creating a SQLServer front end?

I've been looking into this myself and seeing everything from Visual Basic to Access to ASP, from Web to Windows.

Here's my situation. I need to create a few simple tools for our office folks to use. For example, a tool that creates an invoice using data from two tables (Customers, Items).

I'd like to make it as simple as possible for them (ex. setting up an autocomplete for the customer name, etc.).

Please understand, I'm not looking for anyone to write code for me. I just want some feedback on what tools to use.

I would just use Access (since I am familiar with it), but we don't have it here. Sigh.

Any thoughts? Personal Preferences?

View 3 Replies View Related

Creating Table When Session Is Invoked

May 6, 2004

Hi,

When I invoke a session in SQL Server I would to create few temp tables. I have got the queries in a file. Is there any way to invoke these queries (Creating Temp tables) whenever I invoke a session.

Any suggestion/guidence would be greatefully received.

Regards,
SAM

View 2 Replies View Related

SQL Security :: How To Create A Low Privilege User And Role For Server Session State

May 26, 2015

An old website I inherited uses sa to connect to SQL SessionState and had the details in the web.config. This is bad for security.The session state database is of -sstype "t" which is defined as:Temporary. Session state data is stored in the SQL Server tempdb database. Stored procedures for managing session state are installed in the SQL Server ASPState database. Data is not persisted if you restart SQL. This is the default.What kind of WIndows user, SQL Login, role and permissions do I need to create to make Session State secure? (Windows Server 2012 and SQL Server 2012 mixed mode authentication, Webfarm).

View 4 Replies View Related

Setting Recover Model With TSQL

Jan 27, 2007

I have a TSQL script that restores a production database to my localdevelopment machine. Every time I do a restore, I have to go intoEnterprise Manager and set the recover model to simple to preventWindows XP Backup from having shadow copy problems (that is a rant inand of itself). I would like to just add a statement at the bottom ofthe script to do this, but have yet to find the proper commandsdocumented. It seems that the instructions that come with the serveronly mention enterprise manager.Thanks in advance for any help.

View 2 Replies View Related

Help With Security Model

Jun 10, 2004

Hi all,

I need some sugestions from all of you about setting up security model in
our SQL2000 box.

The server was setup using Mixed mode. However, all the applications
(web and MS access) access the server using "sa" userid.

There are several databases in our server. Ex: (DB1,DB2,DB3,DB4 and DB5)

Application 1: need read/write access to DB1,DB2 and DB3
Application 2: need read/write access to DB5
Application 3: need read/write access to DB4 and DB3

Should I set up three userids and give them the dbo access to those
database that they need to use?

Does that make any sense to you?

Thank you for all your suggestion

View 5 Replies View Related

Help Me Understand A MS-SQL Security Model

Apr 15, 2008

I'm a bear with a very little brain. Please review the following story to see if I understand the concepts.

For the purposes of this exercise let's say that a database is used to control a building's HVAC (Heating, ventilation and cooling) system. It's installed by the HVAC vendor, who installs client software on the PC's in the building. This software allows the occupants of the building to alter the setting of the HVAC system. A young and foolish programmer/DBA - eager to show his mettle - accepts the responsibility of overseeing the system to make sure it works. What could go wrong? Easy money.



Given: A database that contains securable. (Tables, views, schema's etc).

By the second week, there is always someone complaining that it's too hot, too cold, too noisy (fans on too high). Everyone is setting their own settings. No one is happy - the only thing that they agree on is that the system doesn't work - and it's up to the less-young and less-foolish programmer/DBA to fix it.

Option #1: Create an Application Role (AIR_GOD) to control who can really write to the thermostat tables. This effectively blocks anyone who doesn't know the AIR_GOD password from fiddling. This password is only given to a carefully selected few.

Two weeks and fourteen passwords later:

Option #2: Create a fixed database role (AIR_GOD2) and drop only the selected few logins into it. (Our programmer is learning)

It helps. But since the users can access the whole thermostat-table - they end up setting each other's zones settings - sometimes by accident. Sometimes the values entered are insane.

Option #3: Create a Data Access Layer (DAL) Our programmer/DBA learns fast - he removes update rights to the thermostat-table from all users with a login. Now the only way to change a thermostat-table setting is through the stored-procedure(s) with the 'user without a login' impersonation. Values are checked before they're written etc.

Is that about right?

(Our story ends with the programmer/DBA growing older and wiser vowing never - ever - ever - to get involved with HVAC control systems again.)

View 1 Replies View Related

Report Model Security

Feb 6, 2008

I have been playing with SRS 2005 for a few months now and have a decent setup going but am strugling with model security.

I have set my selected users up in the home folder and also as site users in site settings, they can launch the report builder and create reports fine.

HOWEVER

I intend to use the software accross multiple systems ie WMS, TMS, Finance package, T&A and therefore I only want the WMS users to see the WMS models and T&A users to only see the T&A models etc

No matter what settings are adjusted it seems that if you can launch the report builder then you can access all models and this poses an issue for me as systems like T&A and financials that I need to be as secure as possible.

I am aware that I can limit access to to models using Management studio but it seems to be basically on a column basis rather than the whole model.


Help!!!


Also aware of the fact im an idiot and basically posted the same thing 5 or 6 times! Hopefully the others are deleted

View 3 Replies View Related

Upgrading 6.5 To 7.0 And Retaining Security Model

Dec 30, 1999

Is is possible to upgrade from 6.5 to 7.0 and have all the logins that have been granted the ability to make a trusted connection to 6.5 be created the same capability in 7.0?

When I did it the logins were created as standard logins in 7.0

View 1 Replies View Related

Setting Up Security

Jan 16, 2007

Hi all,

Okay, here's my problem:

After I login into the Reports Server (<servername>/Reports1/Pages/UILogon.aspx?) the Home page is blank ( accpet for links to Home |MySubscriptions | Help in the upper right corner). Please read on before thinking you know the answer. I am using Reporting Services with Forms Authentication with a custom security extension. In the LogonUser methothd I validate the user and return True if the user is good. Should I be doing anything else in this method or any of the other methods in my custom extension? I'm asking because, I can use Sql Server Management Studio to login into the Reporting Server, view any folders such as the Data Sources or Models folder, but can't make any changes. In the Users table in the ReportServer database the user I'm logging in with has a UserType of 0 and AuthType of 3. I've tride changing these to match the BUILTINAdministrators user but still no luck. Also, I can not login as the BUILTINAdministrators because that user would not be in our database. Any help with this is appreciated. Thanks.

View 4 Replies View Related

Setting Security On DB

Jul 18, 2006

New to this game so please bare with me ;)

const string ConnectionString = "Data Source='db.sdf';";

SqlCeEngine mydb = new SqlCeEngine(ConnectionString);

mydb.CreateDatabase();

create table Eaddress (OID int IDENTITY, title nvarchar(20), name nvarchar(80), lastname nvarchar(70)

)";



database is created and works but how do i set a username and password for the db (an example would be great)

View 3 Replies View Related

I Have A Question On The Security Model For MSRS 2005

Sep 21, 2007

I have a question on the security model for MSRS 2005. I have been working with the permissions for the reporting server folders and reports at my company. Now it seems to me that I can let a user have access to a folder but they will not be able to see any reports that they do not have permissions to see. This would seem different from the Windows Security model where I can see an executable but not actually execute it. (ie. In MSRS the user would be able to see the report but not execute it)

Am I correct in this assumption or is there a way to allow the user to see the report but not execute it using the MSRS permissions.

View 1 Replies View Related

Report Model Item Security Has No Effect

Apr 25, 2007

Hi,



I am trying to use a very easy and simple feature of a reportmodel, model item security.

In my example i have two users; HGHJohn and HGHJKooi



I want to test if I am able to restrict access in the model to a whole entity. HGHJKooi shouldn't be able to see the entity 'Customers'.



These are the steps I executed:

1. In Sqlserver management studio I opened the properties of my model and navigated to the tabpage 'model item security'.

2. I activated the option 'secure individual model items...'

3. In the root of the model I declared two users(groups) as specified above

4. Automatically all nodes inherit these settings from the root.

5. For the entity 'Relations' I change the default, by selecting 'use these roles for each group or user account'

6. I removed HGHJKooi from this list, leaving only 'HGHJohn as model item browser



What I expected at this moment is that when I login the system as HGHJKooi, then I won't see this entity, but I still can! Does anybody know a solution to this problem?



Julian Kooiker

View 1 Replies View Related

Report Builder - Data Model(Security)

Feb 8, 2007

Hi all

I have created security roles that restrict access to a certain Dimension
and a member therein.

The security works fine when the users finened in it runs a report:
The data is accordingley ristricted.

The problem is when those same users run Report Builder and create a report,
those members are no longer restricted and they have acces to absoluteley
all data from the cubes.

Is there some way that I can force the Data Model to follow the cube's security roles?

Any help is much appreciated...

Gerhard Davids

EDIT:
I have found that it uses the wrong user when opening report builder.
For some reason it uses my windows account instead of the one I used to log onto
report manager. This is way the security isnt working

Any thoughts what may be causing this?

View 3 Replies View Related

Setting Up NT Security In SQL Server 7

May 10, 2000

Does anyone know the best way to set up NT security. It seems a little confusing as to how to set up NT groups and assign permissions (where do the roles come into it?).

Any help would be much appreciated

thanks

Paul

View 1 Replies View Related

Lift Chart Failing With Restricted Security Model

Jan 4, 2007

Hello--

We're running into an issue where analysts are having problems obtaining lift charts (via the Mining Accuracy Chart UI available in the Visual Studio Analysis Services project) and performing prediction (via the Mining Model Prediction UI).

The issue seems to be related to the underlying analyst security model. Note that this post is related to:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=924641&SiteID=1


Analysts that work on the same problem will only have access to:

- A sandbox relational database (which contains views into the same source database). The analyst is db_owner of the sandbox database, so she/he can create data transformations required, etc. The sandbox database contains views to the source database, but the analyst only has read-access to the specific data elements needed from the source DB. So, they are very restricted w.r.t. the source database, but are db_owners of their sandbox relational databases. Note that the analyst will connect to he database via Windows Authentication.

- An Analysis Services sandbox database to use for their modeling, etc. In this AS sandbox db, we've created a role called "Administrator" and checked the permissions: Full control (Administrator), Process database, and Read definition. The analyst's windows account is the "user" associated with this role.

Also, in this situation, the SQL Server 2005 Relational Engine and Analysis Services are running on a single machine. The goal of this security model is to provide analysts with the ability to work in their "workspaces" (both SQL and AS), but not to see other analysts work, etc.

Under this model, Analysts are able to deploy mining models when the Data Source object that points to their relational "sandbox" DB is set-up with "Impersonation Information" = "Use a specific user name and password", where the Analyst provides their domain account information.

But, when trying to build a lift chart using the same data source view objects that were used to successfully train the model, the following error is occurring consistently:

Window Title: "Loading Mining Accuracy Chart"
Window Text: "Failed to execute the query due to the following error: Execution of the managed stored rocedure GenerateLiftTableUsingDatasource failed with the following error: Exception has been thrown by the target of invocation. Either '<domain><login>' user does not have permission to access the '' object, or the object does not exist. Errors in the high-level relational engine. A connection could not be made to the data source specified in the query. Errors in the high-level relational engine. A connection could not be made to the data source specified in the query.."

Since the Analyst was able to build the model with her/his given '<domain><login>' credentials, it is puzzling why the lift chart is failing.

Thanks in advance for your help,
- Paul

View 3 Replies View Related

Report Model Security Integration With SSAS 2005

Aug 7, 2006

Hi,

I have a question here for report model generated on top of SSAS 2005. If security has been defined in SSAS 2005 cube where RoleA only have access to certain dimension, is this security setting integrated with the report model and propogate down to the report builder when used where RoleA users have no access to dimension allowed?

Thanks,

J Lim

View 1 Replies View Related

Creating An Erwin Model Of DB

Apr 14, 2005

At work, we have a rather large VB project that uses MSSQL as the back end. This program was used to gather employee data and statistics. The author has since quit and I'm trying to add some functionality to the program. Unfortunately, there is no documentation on the db and there are about 80 tables. Is there any way to create a chart/Erwin Model of some sort that would show the primary keys/relationships between the tables?
Thanks!

View 1 Replies View Related

Setting Folder Security Programmatically

Jul 3, 2007

Hi!



Is there a possibility to set the folder security on the report server programatically?



Thanks



Klaus Aschenbrenner

http://www.csharp.at

http://www.csharp.at/blog

View 1 Replies View Related

Setting Up SRS On Win 2003 - Security Issue

Apr 16, 2008

I am having a little trouble with my SRS installation. I have a fresh-out of the box server running Win 2003. I installed SQL & SRS on it. I have successfully deployed my report project and can run reports, etc.

The problem is, even when logged in on the console as the local admin, I can't seem to perform the usual administrative functions on the report server- simple things like hide items in list view. I have no menu options for any of the security stuff, either. I though that the local admin was able to do these things by default. I have a feeling that this has something to do with active directory & role membership? It is like the administrator only has guest privledges.

When I connect to the report server from management studio, I can see the roles but no information about users, no options ot add users to the roles, either. My goal is to simply add a user (Administrator) to the proper role to be able to configure the report server environment.

For what it is worth, this box is simply set up in my home office, no domain, etc. Please be gentle, I am mainly a SQL geek, very little knowledge of Server OS & Windows security.

Any help is greatly appreciated.
JB

View 1 Replies View Related

User Is Not Able To Access The Database Model Under The Current Security Context

Feb 7, 2008

I have a restriced user on SQL Server that is only permitted to creat a new database and manage it only. All other database are hidden to that user.

when that user login to SQL Server and create a database and try to change the default folder path for data and log files, gets an error,

The Server principal "User" is not able to access the database "model" under the current security context. (MSSQL Server, Error: 916)

Any idea???

Thanks,

View 7 Replies View Related

Creating A Model In Report Manager

Dec 14, 2006

Can anyone help me?

I've read the instructions on the following page

http://msdn2.microsoft.com/en-us/library/ms159118.aspx

about how to generate a report model from a cube.

I can set up the cube as a data source but when I look at the properties there is no option to "Generate Model".

 

I am running SQL 2005 DE SP2(CTP).

 

The option is just not there for me. Any ideas?

 

Thanks in advance

View 5 Replies View Related

Object Model API For Creating RDF Reports?

Nov 14, 2007

I need to create RDF files dynamically. As one example, I need to output a report that contains an OLAP table from an MDX query and will need to generate the RDL that represents the table on the fly. (Binding to a data source with any built-in control will not even come close to solving the problem. The actual requirements are extremely complex.)

In short... Rather than outputting the RDL XML the hard way is there an object model I can use to construct an RDL document with? Even if it's a bindhind-the-scenese, not-supported library?


Thanks,
Terry

View 1 Replies View Related

Creating A Report Model On A UDB Datasource

Aug 30, 2006

Hi all,



I'm just getting started with Reporting Services and have a question.

I'm trying to set up a report model based on a UDB data source. However when I use the report model wizard, I get presented with:

[DB2/SUN] SQL0104N An unexpected token "SET TRANSACTION" was found following "BEGIN-OF-STATEMENT" ... SQLSTATE 42601.

I think that this is trying to set transaction isolation levels however this is not valid SQL for a UDB database.

Is there something that I'm missing with my configuration to make RS know that this is a non-SQLServer database?



Many thanks,

JK

View 1 Replies View Related

Master Data Services :: Setting Read Permission On Entity Attribute Makes Model Disappear

May 21, 2013

My company is new to MDS. I am trying to set an attritube in an entity to read only so the users can't change the value in that field. When I did that, the whole model disappeared. I thought I had deleted it by accident so I created a test model and tried to do the same. The test model disappeared. This time, before saving the new settings I took a snapshot. After saving I took another snapshot. You can see that the whole model is gone (zz_RN_Permissions_Test). I tried every other coworker with admin rights and nobody shows it on the Models list. The behavior on the Excel add-in is correct. I can't change any values on that column. But I need to keep the models available.

See before and after snapshots below.

View 8 Replies View Related

Asp.Net Not Finding The SQLServer For Setting Up Security Problem

Aug 19, 2005

I have just reciently installed and started upgrading the last beta code to this beta and am having a problem conecting to my sqlinstance with the WebSite Configuration Tool.

View 16 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved