Creating Role error

Question

Post reply

Creating Role error

travis.whitley

SSC Rookie

Points: 34
More actions
June 16, 2008 at 10:12 am

#94206

nice.

Viewing 9 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 1

IDENTIFIED BY is not part of SQL Server's create role statement. The form of create role is

CREATE ROLE role_name [ AUTHORIZATION owner_name ]

so, as an example,

CREATE ROLE buyers AUTHORIZATION dbo

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Steve Jones - SSC Editor SSC Guru Points: 738850 More actions · Answer 2

Steve Jones - SSC Editor

SSC Guru

Points: 738850

June 16, 2008 at 10:36 am

#829327

What's a "promotional DBA"

travis.whitley SSC Rookie Points: 34 More actions · Answer 3

was supposed to be funny. i guess cultural references dont work on forums;)

Grant Fritchey SSC Guru Points: 399289 More actions · Answer 4

OK, but what did it mean?

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 5

travis.whitley (6/16/2008)
was supposed to be funny. i guess cultural references dont work on forums;)

I think we all missed the joke.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Steve Jones - SSC Editor SSC Guru Points: 738850 More actions · Answer 6

Ah, interesting. Which culture?

Promotional here means advertising or announcing.

I can't think of one, but I'm sure that there would be something funny to use in the US. Maybe Pseudo-DBA

Grant Fritchey SSC Guru Points: 399289 More actions · Answer 7

Provisional-DBA? But that'd be true & not funny.

Uhm... wanna-be-DBA?

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Carl Federl One Orange Chip Points: 25384 More actions · Answer 8

Promotional activities are those that advance software thru the various phases such as usability testing, functionallity testing, performance testing and finally to productions.

For the US, the Sarbanes-Oxley Act titled "Public Company Accounting Reform and Investor Protection Act of 2002", most companies use a Change Control process that requires that promotional activities may not be performed by any personnell involved in the development of the software.

I seem to spend of lot of my Saturday nights as a promotional DBA.

I also spent most of this morning tracking down an un-authorized changes that was made to a production application this weekend.

SQL = Scarcely Qualifies as a Language