|
Hi, I would like to know if it is possible to determine sql role to which a user belongs. I would want my client application to enable and disable some menu items if it is able to determine the sql role to which that user belongs. I'm using Sql Server 2005. Thanks.
|
|
|
|
|
Are you talking about the server roles withing sql server or the active directory roles. It would be weird to use server roles to manage your UI and AD roles should be retrieved via the UI.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Some users will be administrators, and I will create my own roles as well. That means I will check both the server roles and user-defined roles for a database.
|
|
|
|
|
Check this[^] and it depend how you plan to manage rights on application.
I Love T-SQL
"VB.NET is developed with C#.NET"
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
Blue-Boy you took me to Google. Well I have already googled and didn't find a clear solution. But I will keep trying.
|
|
|
|
|
|
Hi everyone, I would like to know how an administrator can change the password of a user who has forgotten his or her password. Using sp_password requires the old password before the change can be made. I would be happy to know how to solve this problem. But if it is possible to retrieve the password for a user, that will solve the problem and I will be glad to know how to retrieve a user's password if I am an administrator. Thanks in advance.
|
|
|
|
|
|
Thanks. I got it. That was about changing the password. But is there also a way to view users' password? Looks like that was not described there.
|
|
|
|
|
I don't know off-hand, but I doubt it. Any system worth its salt will never allow passwords to be displayed, only reset. If you allow the administrator to view a user's password then it is open to hackers; not a good thing.
|
|
|
|
|
Thanks again Richard. Then I will stick to resetting passwords. That will greatly help.
|
|
|
|
|
Richard MacCutchan wrote: Any system worth its salt will never allow passwords to be displayed
I see what you did there 
|
|
|
|
|
Funnily enough this is a perfectly normal English expression (but I guess you know that), and it was only after posting that I noticed the significance of that word.
|
|
|
|
|
Give you both a five to counter the 1.
Arrrrgh.
|
|
|
|
|
Thank ee Jim lad! Some scurvy knaves be cruisin' around these 'ere parts!
|
|
|
|
|
How to increase time of SQL connection timeout property in VB.NET
|
|
|
|
|
You should use the SqlConnection.ConnectionTimeout property to adjust the timeout time of the connection. Here[^] is the MSDN page which gives some examples.
Hope this helps
When I was a coder, we worked on algorithms. Today, we memorize APIs for countless libraries — those libraries have the algorithms - Eric Allman
|
|
|
|
|
What is the physical nature of your network that makes you think that is necessary?
|
|
|
|
|
Why would the network have anything to do with the connection timeout requirements?
If he is running a long stored proc then the timeout is relevant on the connection and the network latency is irrelevant.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Is that not CommandTimeout?
|
|
|
|
|
I beleive there is a difference but would have to look it up, probably the command timeout is effective for the current command where a connection timeout is for all commands on the connection.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
On the app I wrote for working with large datasets that can take over an hour to process certain fetch events, I have set my connection timeout to 5 seconds, and the command timeout to 0 (ie never timeout). works a treat.
|
|
|
|
|
Sure but that has nothing to do with the network 
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Thats why you confused me with this;
Mycroft Holmes wrote: If he is running a long stored proc then the timeout is relevant on the connection
The long running should be on the command, not the connection, or you should have said irrelevant on the connection.
Anyway, doesn't matter, we'll leave it there, I need a cuppa...... 
|
|
|
|
|
Mycroft Holmes wrote: Why would the network have anything to do with the connection timeout
requirements?
What other enterprise constraint would require changing it?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
