Passwords are assigned to logins which are at the server
level. And only sysadmins and securityadmins can execute
sp_password. But that's at a server level, not the database
level. So no, not if you want to restrict it to just one
database.
-Sue
On Tue, 27 Sep 2005 06:52:25 -0700, "Emma"
<Emma@discussions.microsoft.com> wrote:
>How can I assign a user the ability to change/reset password for users
>assigned to one particular database only in EM. Example, Northwind is one of
>the databases in my system; I want the user john to be responsible for
>changing/resetting password for users with access to Northwind database only
>and nothing else. Is this possible? If so, how do I do it?
>
>Thanks
>Emma
Re: Pathname to access and usernames in shortcut ... >> network drive (for maintenance reasons initially, ... >> using usernames but no passwords.... change their passwords within the access database (they won't know how ... >> gets the current username from the system and then calls access (via the ... (microsoft.public.access.security)
Re: security issues ... It was obviously never meant to be; multiple defences against it being ... The Ubuntu installer uses a framework called debconf to do ... when you're asking for passwords... you take a lot of care to clean them out of the database... (Ubuntu)
Re: Basic security questions ... > question be able to open the database in the appropriate view. ... > Isn't there any way to just set up users with passwords that are saved ... How would I specify a relative path for the ... The path to the workgroup file is defined in a shortcut in the format: ... (microsoft.public.access.security)
Re: Windows service ... if you know all of this why you recommend to Rotsey not to use Domain Security?... It's easily cracked, doesn't have any metering on it to prevent brute force attacks, transmits the credentials to the database in plain-text, and doesn't integrate at all into the standard security infrastructure already being used by the organization. ... There's no default monitoring of the invalid password attempts, no automatic account lock-out, etc. There's a ton of documentation on this found on the web. ... It's one less set of passwords to remember, less configuration in the long run, fewer plain-text passwords floating around in email & config files. ... (microsoft.public.dotnet.languages.csharp)
Re: Security Problem with Access 2000 ... has the user names, personal ID's, and passwords.... I backed up the database on a CD. ... If you have the report with the user information, then you should be able to open the database with that information. ... Make sure that you're using the correct workgroup file (the wizard normally creates a desktop shortcut; ... (microsoft.public.access.security)
