Under Security - Logins, right-click the user and hit properties. (IN
SQL 2000)Go to the database access tab, select the db you want to grant
access to then give the rights below. By default, you only grant
public.
natasha wrote:
> Good morning everyone,
> I've a user listed in "Security/Logins".
> If I right/click a database, Properties, "Permission" tab, I can't "Add" i
t
> to database's "Users or roles": if I "Browse" for users, it isn't listed.
How
> can I add?Yes, and in SQL 2005 "database access" tab has been substituted by "User
mapping" tab. But, owner of the database is dbo, and differently from other
DBs, I can't substitute, even if I am the super-non-plus-ultra-admin.
Is there any way to force a "take ownership" of the database?
"PSPDBA" ha scritto:
> Under Security - Logins, right-click the user and hit properties. (IN
> SQL 2000)Go to the database access tab, select the db you want to grant
> access to then give the rights below. By default, you only grant
> public.
> natasha wrote:
>|||Good morning everyone,
I've a user listed in "Security/Logins".
If I right/click a database, Properties, "Permission" tab, I can't "Add" it
to database's "Users or roles": if I "Browse" for users, it isn't listed. Ho
w
can I add?|||Under Security - Logins, right-click the user and hit properties. (IN
SQL 2000)Go to the database access tab, select the db you want to grant
access to then give the rights below. By default, you only grant
public.
natasha wrote:
> Good morning everyone,
> I've a user listed in "Security/Logins".
> If I right/click a database, Properties, "Permission" tab, I can't "Add" i
t
> to database's "Users or roles": if I "Browse" for users, it isn't listed.
How
> can I add?|||Yes, and in SQL 2005 "database access" tab has been substituted by "User
mapping" tab. But, owner of the database is dbo, and differently from other
DBs, I can't substitute, even if I am the super-non-plus-ultra-admin.
Is there any way to force a "take ownership" of the database?
"PSPDBA" ha scritto:
> Under Security - Logins, right-click the user and hit properties. (IN
> SQL 2000)Go to the database access tab, select the db you want to grant
> access to then give the rights below. By default, you only grant
> public.
> natasha wrote:
>|||Have you tried using the following stored procedure on the database where yo
u
wnat the user to have access to:
EXEC sp_adduser 'loginname', 'username'
See if that works or give any error?
Lucas
"natasha" wrote:
[vbcol=seagreen]
> Yes, and in SQL 2005 "database access" tab has been substituted by "User
> mapping" tab. But, owner of the database is dbo, and differently from othe
r
> DBs, I can't substitute, even if I am the super-non-plus-ultra-admin.
> Is there any way to force a "take ownership" of the database?
>
> "PSPDBA" ha scritto:
>|||Have you tried using the following stored procedure on the database where yo
u
wnat the user to have access to:
EXEC sp_adduser 'loginname', 'username'
See if that works or give any error?
Lucas
"natasha" wrote:
[vbcol=seagreen]
> Yes, and in SQL 2005 "database access" tab has been substituted by "User
> mapping" tab. But, owner of the database is dbo, and differently from othe
r
> DBs, I can't substitute, even if I am the super-non-plus-ultra-admin.
> Is there any way to force a "take ownership" of the database?
>
> "PSPDBA" ha scritto:
>|||I tried to, and I've quite a curious error:
Msg 15063, Level 16, State 1, Line 1
The login already has an account under a different user name.
"Lucas Kartawidjaja" ha scritto:
[vbcol=seagreen]
> Have you tried using the following stored procedure on the database where
you
> wnat the user to have access to:
> EXEC sp_adduser 'loginname', 'username'
> See if that works or give any error?
> Lucas
> "natasha" wrote:
>|||> Is there any way to force a "take ownership" of the database?
sp_changedbowner
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"natasha" <natasha@.discussions.microsoft.com> wrote in message
news:FBFC25FE-C6C8-4B8E-A769-419169EF1DDB@.microsoft.com...[vbcol=seagreen]
> Yes, and in SQL 2005 "database access" tab has been substituted by "User
> mapping" tab. But, owner of the database is dbo, and differently from othe
r
> DBs, I can't substitute, even if I am the super-non-plus-ultra-admin.
> Is there any way to force a "take ownership" of the database?
>
> "PSPDBA" ha scritto:
>|||I tried to, and I've quite a curious error:
Msg 15063, Level 16, State 1, Line 1
The login already has an account under a different user name.
"Lucas Kartawidjaja" ha scritto:
[vbcol=seagreen]
> Have you tried using the following stored procedure on the database where
you
> wnat the user to have access to:
> EXEC sp_adduser 'loginname', 'username'
> See if that works or give any error?
> Lucas
> "natasha" wrote:
>sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment