Grant permissions on database - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Grant permissions on database

Author

Topic

Guestuser18
Starting Member

34 Posts

Posted - 2009-12-09 : 05:39:15

Hi all

I have some permissions which I grant on an oracle database however I now need to grant them on a Sql Server 2005 database.
The permissions are:

grant all privileges on sys.dba_pending_transactions to system with grant option;

grant all privileges on sys.pending_trans$ to system with grant option;

grant all privileges on sys.dba_2pc_pending to system with grant option;

grant all privileges on sys.dbms_system to system with grant option;

If anyone can at least give me the sql version of these that would be great or if not point me in the right direction.

Thanks in advance.

bklr
Master Smack Fu Yak Hacker

1693 Posts

Posted - 2009-12-09 : 06:10:04

USE databasename
GO
EXEC sp_addrolemember N'db_owner', N'loginname'
GO

Guestuser18
Starting Member

34 Posts

Posted - 2009-12-09 : 06:41:27

Hi

Thanks for the reply to my query. I have run the code and it worked.

I have final 4 queries to be run:

GRANT SELECT ON SYS.DBA_PENDING_TRANSACTIONS TO "schema name";

GRANT SELECT ON SYS.PENDING_TRANS$ TO "schema name";

GRANT SELECT ON SYS.DBA_2PC_PENDING TO "schema name";

GRANT EXECUTE ON SYS.DBMS_SYSTEM TO "schema name";

Any help on these would be great as well!

Cheers

Guestuser18
Starting Member

34 Posts

Posted - 2009-12-09 : 08:57:15

Hi guys

I would have thought that the code that was provided by bklr would have solved my problem for all 8 queries that I have provided above, however it hasnt.
Is there something additonal I need to do in relation to the 2nd set of queries I have provided?

Thanks

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources