I am not understanding the permission problem I am having and what the Schema object is for. My Database has Stored procedures owned by a user, let say corp. If I look at the database there is a Schema also called corp owned by corp. corp has all roles except db_DenyDatareader and db_DenyDatawriter and is not aliased to dbo. Now it has been my understanding that since the user corp owns the Stored procedure it should have execute rights to it. The problem is when my application opens and tries to execute a stored procedure I get denied for lack of Execute permission. If I log into the database using enterprise manager (2005 version) with the corp login I can get into the database but I can not see any of the Stored procedures that the corp user owns. I can not figure out this issue any ideas are greatly appreciated. Thanks
mtone
Posts
-
SQL 2005 Execute permissions -
Explaination of syntax in .Net 2.0I have been seeing the following code I do not know what the characters mean in a web page <%$ Tranlate: any string value %> I know that translate is a function in the code and it is translateing the any string value to another string but could you tell me what the $ means how is it different then <%# and what the : does In some code I also find NewRow!somefield = somevalue what does the ! mean and what does it do Thanks
-
XML Encoding Stripped when LoadedI am using vbscript to execute web services. Normally we can leave encoding out of the declaration line but we need it for chinese characters. When I load the xml from a stream (.LoadXML(...)) the encoding attribute gets stripped from the page declaration. If I try to load the file into the DOM it errors with no reason. Even If I try to set the declaration after loading it still does not showup in the XML Text.
InputFolderXML = XMLTEXT from a file Set XmlInputDoc = CreateObject("Msxml2.FreeThreadedDOMDocument.4.0") LoadXmlResult = XmlInputDoc.loadXml(InputFolderXML) XmlInputDoc.CreateXmlDeclaration "1.0", "gb2312", Nothing
Any Help will be greatly appreciated Thanks Joe -
sequence text boxes nameI would bet you would be better off doing something like using an image of the seating chart as the background of the Form and handling the click event of the form. Get the mouse corrodinates to deterime which seat was clicked. You would have to do some math so you know how big the x and y range is for each seat but I bet you could figure if each seat is 10 X 10 points, for example, and your mouse click was at x y you could find which seat was clicked. I have never done this but that would be the first thing I look at.
-
Web Services and SSLthanks For the response this is the code in my Windows application.
WsProxy.FuturesXiServices proxy = new WsProxy.FuturesXiServices(); proxy.Url = this._url; WsProxy.AuditLogin[] items = proxy.AuditLoginProvider_GetAll(start, pageLength, out count); return Convert(items);
So what you are saying is that this is not protected with encryption if the URL is https://... -
Web Services and SSLIf I have a Windows application that retrieves data using Web Services and I want the data to be secure can I access that Web Service in a Secure Socket using HttpS:// to provice data encryption? Example: Https://www.webservice.com/service.asmx It is my understanding that my Client the Windows app is accessing this in a Secure Socket therefore it is protected. Is that correct? Thanks Joe
-
HotKey IndicatorI have a Winform with a button. The Button Text is set to &RUN. When I open the application the Button does not Display RUN until I hit the Alt key. Is there a way to make this underlined when I open the app. Thanks Joe
-
Can not resize Controls [modified]I am having a sudden problem in VS 2005 with Resizing my controls in a windows form. I can not resize any controls. I can move them but not resize them. I rebooted my machine but I stil can not resize anything. I do not reall any unusal events. Does any one have any ideas. It only seems to one particular Project. Thanks -- modified at 10:43 Saturday 26th August, 2006
-
AppDomain Question [modified]Thanks Dave I have the code that writes to the event log in another function I am using the Enterprise Library to handle the event logging. Well, the event log was not the problem just a way for me to see the exception followed the proper route. I will keep looking at it, so long as I know it should work.
-
AppDomain Question [modified]In the Main (MDI) form My test is just trowing an new exception. Here is gets handled by CurrentDomain_UnhandledException and ultimatly ends up in The EventLog
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load AddHandler Application.ThreadException, AddressOf ApplicationThreadException AddHandler AppDomain.CurrentDomain.UnhandledException, AddressOf CurrentDomain_UnhandledException Throw New Exception("This is a test") End Sub
If I put the sameThrow New Exception("This is a test")
in the onload event of the mdi child it does not get handled nor does it make it to the event log. If I set a break point I can see that CurrentDomain_UnhandledException is never called. Thanks Joe -
AppDomain Question [modified]I have an MDI form where I set the following Handler in Form_Load
AddHandler AppDomain.CurrentDomain.UnhandledException, AddressOf CurrentDomain_UnhandledException
If I throw an exception in the MDI form the exception gets handled by CurrentDomain_UnhandledException But, If I load a child form and throw an exception from the child form the excpetion does not get handled by CurrentDomain_UnhandledException So, Is the child form running in a different AppDomain then the MDI form. How can I get this to work or does this not work the way I thought it would. Here is my form load which is also in the MDI formf = New formDesignErrorsList f.Tag = formname f.Text = f.Text f.MdiParent = Me f.Show()
Thanks -- modified at 22:46 Wednesday 23rd August, 2006 -
Convert integer to time........The Date time Field is going to store the date such as 3/3/2006 along with the time 12:00 AM. If I read this correctly 3.5 represents a measurment of time, 3 and a half hours, and not an actual Time of day. You should look at decimal data type or even a string.
-
Specified cast is not validWhat is this? tblName = (cmbInsertData.Text) setTableName(tblName) I do not see a declaration of the Variable tblName ( Dim tblName as String ). I believe VB will create this as an Object type without the Dim statment, and then you are trying to us it as a string? what is setTableName? are you expecting the variable tblName to change when it comes out of setTableName? Step thru the code line for line in debug and you can see exactly what all your variables are and what might be missing. Joe -- modified at 0:37 Sunday 6th August, 2006
-
Not able to update database [modified]Show The rest of the Code. Where is the Update statement? Do you get an error?
-
populating a dropdown list from an arraylistAre you taking about a ComboBox or ASP.NET Control DropDownList No need for the Loop Just bind the Datasource to the arraylist. dlIdNums.DataSource = idnums dlIdNums.DisplayMember = "name" or DataTextField(ASP) dlIdNums.ValueMember = "value" or DataValueField(ASP) Check Help if I am wrong it is in there.
-
Encryption - Storing Private keysblondie10 wrote:
Now perhaps the only answer to the problem at this level of security would be to objfuscate the code
It is Obfuscate, but who cares you're the friendliest person after all.
-
Adding Textboxes at runtime - too slow.Use a Datagrid
-
Runtime TextBoxesWhen I create textboxes at runtime and place them in a panel the user can not paste a value into them but they can type. Is there a Setting I have to use to allow this? Thanks Joe
-
Demo To Full VersionI think this would be far to complex to just post here. There are Install packages that handle this or you would need to figure out how to create keys for products, encrytion, storing them , generating a license ( temp or perm), protecting the keys, Checking this information in your application code etc... If you do not want to buy install software try this free open source product http://www.activelocksoftware.com/[^]
-
Are sql query command strings secure in ASP.NET?You should probably worry about what is in the Text field of the text box. Malicious code could be passed into the database if you do not strip it and you should parameterize your queries, never Concatenate strings to create a sql statement.